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. ...
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...
PV Function - Get the Present Value in Excel
Tutorial: The Present Value (PV) function in Excel will return the current value of an investment....



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.