Formula To return the MONDAY of current week

[MDuff]

Hi,

I am looking for a Formula that will return the Date of the Monday of the Current week IE every week it updates to the Monday of the current week

thanks a lot in advance

 

[tushiroda]

think this might do it

=DATE(YEAR(A1),MONTH(A1),DAY(A1) + 2-WEEKDAY(A1))

 

[MDuff]

thanks Just had to add Today() in A1

 

[barry houdini]

Assuming that you want the current day on a Monday but the previous Monday on any other day you could use

=A1-WEEKDAY(A1,3)

If you don't want/need today's date in A1 just put that in the formula

=TODAY()-WEEKDAY(TODAY(),3)