June 10, 2024
Excel Forum Top Contributors:
HansV MVP - Ashish Mathur - Andreas Killer - Jim_ Gordon - Rich~M ✅
first/last working day of week
Report abuse
Thank you.
Reported content has been submitted
If your week begins on Sunday and the first working day is Monday, then the date of the Monday in the current week is:
=CHOOSE(WEEKDAY(TODAY()),1,0,-1,-2,-3,-4,-5)+TODAY()
Report abuse
Thank you.
Reported content has been submitted
1 person found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
In the subject you use Working day and in the description you use Weekday. In Excel these are 2 different things. Working days exclude weekends and can optionally exclude any dates identified as holidays. (Need a separate list of holiday dates created in your workbook.)
Weekdays is the 7 days of the week.
If you are just looking for Monday and Friday then the following.
Return Monday of current week based on today's date:
=TODAY()-WEEKDAY(TODAY(),1)+2
Return Friday of current week based on today's date:
=TODAY()-WEEKDAY(TODAY(),1)+6
Caveat:
If today() is Sat then returns the date of previous Mon and Fri.
If today() is Sun then returns the following Mon and Fri.
OssieMac
Report abuse
Thank you.
Reported content has been submitted
3 people found this reply helpful
·Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Question Info
Last updated June 6, 2024 Views 4,294 Applies to: