Manuals/calci/EOMONTH
Jump to navigation
Jump to search
Syntax
Examples
''''''' ''''
Description
EOMONTH
EOMONTH(sd,M)
where sd is a date that represents the starting date and M is the number of months before or after start date.
EOMONTH gives the serial number for the last day of the month that is the indicated number of months before or after start date. It is used to calculate maturity dates or due dates that fall on the last day of the month.
Let's see an example in Column1Row1
C1R1 = 03/02/2007
I.e =EOMONTH(C1R1,1) is Mon Apr 30 00:00:00 UTC+0530 2007(Date of the last day of the month ,one month after the date above)
///rly =EOMONTH(C1R1,-2) is Wed Jan 31 00:00:00 UTC+0530 2007(Date of the last day of the month, two months before the date above)
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 03/02/2007 | Mon Apr 30 00:00:00 UTC+0530 2007 | Wed Jan 31 00:00:00 UTC+0530 2007 | |
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
