setting the date to monday

M

Mortir

is there a way the i could create a formula that would check the
current date and then set the date to monday of the week.

examples:
on date 07.Nov 07. The formula would give me 05.nov 07 (monday)
on date 23. Nov 07. The formula would give me 19.nov 07(monday)
 
C

carlo

is there a way the i could create a formula that would check the
current date and then set the date to monday of the week.

examples:
on date 07.Nov 07. The formula would give me 05.nov 07 (monday)
on date 23. Nov 07. The formula would give me 19.nov 07(monday)
Click to expand...

=NOW() - WEEKDAY(NOW(),3)

NOW = Date today
WEEKDAY = monday:0, tuesday:1 and so on

hth

Carlo
 
R

ryguy7272

Last Monday:
=TODAY()-WEEKDAY(TODAY())+2


Next Monday:
=TODAY()+6-MOD(WEEKDAY(TODAY())+4,7)
=TODAY()-WEEKDAY(TODAY()-2)+7
=TODAY()-WEEKDAY(TODAY(),2)+8


Regards,
Ryan---
 
Top