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


"carlo" wrote:

On Nov 7, 4:27 pm, Mortir wrote:
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