Dueling Excel 033


First Monday For Reporting Period

DESCRIPTION

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

WORKBOOKS




Be the first to comment

Leave a Reply