Add months to a date

Dates are represented as date serial numbers.
You can add a certain number of months to an existing date by adding the corresponding number of days in that month.

1=TODAY() = 16/10/2019
2=NOW() = 16/10/2019
3=EDATE(A1,1) = 43785
4=EDATE(A1,3) = Thursday, January 16, 2020
5=DATE(YEAR(A1),MONTH(A1)+3+1,0) = Friday, January 31, 2020
6=DATE(YEAR(A1),MONTH(A1+3),MIN(DAY(A1),DAY(A5))) = 16/10/2019

Built-in Functions

NOW - The serial number of the current system date and time.
TODAY - The serial number representing today's date.
EDATE - The date serial number that is a certain number of months before or after a date.
DAY - The day as an integer given a date serial number.
MIN - The smallest value in a list or array of numbers.
MONTH - The month as an integer given a date serial number.
DATE - The date as a date serial number given a year, month, day.

Related Formulas

Add days to a date including weekends
Add weeks to a date
Add years to a date
Subtract months from a date
Number of days in a particular month
Number of months between 2 dates
Return the number corresponding to a given month

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top