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. ...
PV Function - Get the Present Value in Excel
Tutorial: The Present Value (PV) function in Excel will return the current value of an investment....
RATE Function - Calculate an Interest Rate in Excel
Tutorial: The Rate function in Excel (RATE) calculates the interest rate for a financial transaction...



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.