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.

Cell "A1" displays the current date. Custom format "dddd dd mmmm yyyy".
Cell "A2" displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".

1=TODAY() = Wednesday 31 March 2021
2=NOW() = Wednesday 31 March 2021 17:18:12
3=EDATE(A1,1) = 44316
4=EDATE(A1,3) = Wednesday, 30 June, 2021 12:00 AM
5=DATE(YEAR(A1),MONTH(A1)+3+1,0) = Wednesday, 30 June, 2021 12:00 AM
6=DATE(YEAR(A1),MONTH(A1+3),MIN(DAY(A1),DAY(A5))) = Friday, 30 April, 2021 12:00 AM

Built-in Functions

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

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

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