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.
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".

 A
1=TODAY() = 02/12/2019
2=NOW() = 02/12/2019
3=EDATE(A1,1) = 43832
4=EDATE(A1,3) = Monday, March 02, 2020
5=DATE(YEAR(A1),MONTH(A1)+3+1,0) = Tuesday, March 31, 2020
6=DATE(YEAR(A1),MONTH(A1+3),MIN(DAY(A1),DAY(A5))) = 02/12/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