MONTH Archives - ExcelHappy

How to: Get the Quarter End Date for any input date

Post author:
Post published:
Post category:Tips & Tricks
Post comments:0 Comments

Given a date in Excel we can calculate it's Quarter End date easily using one of a number of inbuilt functions in a formula. Find the one which fits your circumstances best...

How to: Get the First Day of the Month for any input date

Post author:
Post published:
Post category:Tips & Tricks
Post comments:0 Comments

Excel provides at least 3 options for calculating the first day of any month. Either using the DATE function, the EOMONTH function or the DAY function. Read on to find out how...