Formula should include Monday and all subsequent dates, is that not
correct?

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

gives the date of the previous Monday (on Monday it gives that day's
date)

WEEKDAY function has 3 possible settings, I'm using the third one
(hence the 3) which assigns numbers to days as follows

Monday = 0
Tuesday = 1
....etc.
Sunday = 6


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=568116