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