Excel Forum
Similar Content
Return the ISO Standards Start of the Year in Excel - First Monday of the Year - UDF
Macro: Return the date of the first Monday of any year with this UDF ISO Year function in Excel. ...
NPER Function - Calculate Number of Periods Needed for a Set of Payments in Excel
Tutorial: How to calculate the number of periods required for an investment in order to get the desi...
FV Function - Get the Future Value in Excel
Tutorial: The Future Value function (FV) in Excel will return the future value of an investment ba...



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.