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.


Example

 A
1=TODAY() = Saturday 01 June 2024
2=NOW() = Saturday 01 June 2024 06:36:09
3=EDATE(A1, 1) = 45474
4=EDATE(A1, 3) = Sunday, 01 September, 2024 12:00 AM
5=DATE(YEAR(A1), MONTH(A1)+3+1, 0) = Monday, 30 September, 2024 12:00 AM
6=DATE(YEAR(A1), MONTH(A1+3), MIN(DAY(A1), DAY(A5))) = Saturday, 01 June, 2024 12:00 AM

1 - Displays the current date. Custom format "dddd dd mmmm yyyy".
2 - 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".


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, table or cell range.
MONTH - The month as an integer given a date serial number.
NOW - The date serial number of the current system date and time.
TODAY - The date 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


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