Home / Discussions

Report Offensive Message

excel Version
You could just use her formula in the cell you want the Monday to appear. Replace date with TODAY()
IF(WEEKDAY(TODAY())=1,TODAY()-6,TODAY()-(WEEKDAY(TODAY())-2))
Posted by winlak
25th Oct 2011