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".

1=TODAY() = Tuesday 07 April 2020
2=NOW() = Tuesday 07 April 2020 14:46:40
3=EDATE(A1,1) = 43958
4=EDATE(A1,3) = Tuesday, July 07, 2020
5=DATE(YEAR(A1),MONTH(A1)+3+1,0) = Friday, July 31, 2020
6=DATE(YEAR(A1),MONTH(A1+3),MIN(DAY(A1),DAY(A5))) = 07/04/2020

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

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