Manuals/calci/EDATE
Jump to navigation
Jump to search
Syntax
Examples
''''''' ''''
Description
EDATE
EDATE(sd,M)
where sd is a date that represents the start date and M is the number of months before or after start_date.
It gives the serial number that represents the date that is the indicated number of months before or after a specified date (the start date). It is used to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.
Let's see an example in Column1Row1
I.e. C1R1 = 07/14/2007
I.e. =EDATE(C1R1,1) is Tue Aug 14 00:00:00 UTC+0530 2007(the date one month after the date above)
example2
///rly
=EDATE(C1R1,-1) is Thu Jun 14 00:00:00 UTC+0530 2007(the date one month before the date above)
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 07/14/2007 | Tue Aug 14 00:00:00 UTC+0530 2007 | Thu Jun 14 00:00:00 UTC+0530 2007 | |
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
