First day of week-Monday.

  • Thread starter Thread starter Jimmy Joseph
  • Start date Start date
J

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