Excel Forum

Mr Excel & excelisfun Trick 33: First Monday For Reporting Period

See Mr Excel and excelisfun show three formulas for finding first Monday of reporting period:
If 1st day of month is Monday, then that day, otherwise the last Monday of the previous month. See the functions EOMONTH, WEEKDAY, DATE, MONTH, IF and DAY

Got a Question? Ask it Here in the Forum.