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.