First day of week-Monday.

[Jimmy Joseph]

Hello,

Could you please explain this formula? This returns the first day of a
week(monday) in excel.

=IF(WEEKDAY(TODAY())=2,DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-
WEEKDAY(TODAY(),3))-7,DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-
WEEKDAY(TODAY(),3)))

Regards,

Jimmy Joseph

 

[Peo Sjoblom]

Why use such a thing?

=TODAY()-WEEKDAY(TODAY()-2)

will return the same dates

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey