first/last working day of week

Evening,

Is there a formula that will show the first weekday of the current week (and the last one please)?

i.e now it would show 20/02/2012...

Hope this is clear

Guinea P
Answer
Answer

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()

GSNU2020

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.

Answer
Answer

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.

 

 

Regards,

OssieMac

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 March 1, 2024 Views 4,257 Applies to: