This is part II of amazing date formulas where we’ll learn about EDATE() and EOMONTH().
EDATE(): This formula returns a date that is a certain number of months before or after a specific date. This is very useful for when you need to calculate a date that falls on the same day a certain number of months in the future or past. In this example, I have an investment that compounds on the 14th day every three months. In cell C9 is the beginning date that we will increment by 3 months.
Put the formula =EDATE(B9,C5). This is telling Excel to start at 1/14/14 and increment by 3 months. You can now drag the formula down as many rows as needed.
=EOMONTH(): This formula returns the last day of the month. This formula can be used in a similar way as the formula above (except it returns the final day of the month). We’ll use the same example as above, except we’ll use the EOMONTH() function. In cell B9, we’ll put “0” in for Months which returns the current dates end of month.
Now in cell B10, we’ll put a similar formula to the EDATE() formula above. This will return the end of month every 3 months. We can then drag this down.
Enjoy these amazing date functions and never manually type a date again!