EDATE

EDATE(start_date, months)

Returns the date serial number that is a certain number of months before or after a date.

start_dateThe start date.
monthsThe number of months before or after the "start date".

REMARKS
* This function can be used to calculate maturity dates or due dates that fall on the same day on the month as the date of issue.
* If "start_date" is not a valid date, then #VALUE! is returned.
* If "months" is not an integer, it is truncated.
* If "months" > 0, then a date in the future is returned.
* If "months" > 1E21, then #NUM! is returned.
* If "months" < 0, then a date in the past is returned.
* If "months" = 0, then "start_date" is returned.
* This function respects leap years.
* You can use the DATE function to return the date serial number given a year, month, day.
* You can use the DATEVALUE function to return the date serial number for a date in text format.
* You can use the EOMONTH function to returns the date serial number of the last day of a month before or after a date.
* You can use the TEXT function to convert a date serial number into a particular date format.
* This function does not automatically change the number format of the cell.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=EDATE("01/07/2022", 2) = 44805
2=EDATE("01/07/2022", 2) = 01/09/2022
3=EDATE("01/07/2022", 4) = 01/11/2022
4=EDATE("01/07/2022", -2) = 01/05/2022
5=EDATE("2023/01/09", 0) = 09/01/2023
6=TEXT(EDATE("13 Jun 2023", 3), "dd mmmm yyyy") = 13 September 2023
7=TEXT(EDATE("01/07/2022", 0), "dd/mm/yy") = 01/07/22
8=EDATE(DATEVALUE("01/12/2022"), 1) = 01/01/2023
9=EDATE(DATEVALUE("03/31/2023"), -1) = #VALUE!

1 - What is the date serial number 2 months after the 1st July 2022.
2 - What is the date serial number 2 months after the 1st July 2022. This cell has been formatted with the number format "dd/mm/yyyy".
3 - What is the date 4 months after the 1st July 2022.
4 - What is the date 2 months before the 1st July 2022.

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