setting the date to monday

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

 

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

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

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

hth

Carlo

 

[Guest]

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