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. ...
5 Tips for Evaluating Complex Formulas in Excel
Tutorial: 5 simple tips to evaluate any complex formula in Excel! These tips combine to give you th...
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...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.