Administrators, writer
3,314
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + − Syntax+ + + + + + + + + + − </div></div>+ − ---- − <div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify"> − Examples+ + + + + + + + + + − </div></div>+ − ----+ − <div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div> − ---- − <div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify"> − − <font size="5">Description</font> − − </div></div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="6" face="Arial, sans-serif"><font size="6">'''EDATE '''</font></font> − − '''<font size="6" face="Arial"></font>''' − − </div></div> − ---- − <div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> − − '''<font color="#484848"><font face="Arial, sans-serif"><font size="2">EDATE</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(sd,</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">M</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font>''' − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">where sd</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2"> is a date that represents the start date and M is the number of months before or after start_date. </font></font></font> − − </div></div> − ---- − <div id="1SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">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.</font></font></font></div></div> − ---- − <div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">Let's see an example in Column1Row1</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e. C1R1 = 07/14/2007</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e. =EDATE(C1R1,1) is Tue Aug 14 00:00:00 UTC+0530 2007(the date one month after the date above)</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">example2</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">///rly</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2"><nowiki>=EDATE(C1R1,-1) is Thu Jun 14 00:00:00 UTC+0530 2007(the date one month before the date above)</nowiki></font></font></font> − − </div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"> − − {| id="TABLE3" class="SpreadSheet blue" − |- class="even" − | class=" " | − | Column1 − | Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | class=" " | 07/14/2007 − | class="sshl_f" | Tue Aug 14 00:00:00 UTC+0530 2007 − | class="sshl_f" | Thu Jun 14 00:00:00 UTC+0530 2007 − | class="sshl_f " | − |- class="even" − | class=" " | Row2 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="odd" − | Row3 − | class=" SelectTD" | − <div id="4Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="4Space_Copy" title="Click and Drag over to AutoFill other cells."></div> − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | Row4 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="odd" − | class=" " | Row5 − | class=" " | − | class=" " | − | class="f52543 " | − | class=" " | − |- class="even" − | Row6 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |} − − <div align="left">[[Image:calci1.gif]]</div></div> − ----
no edit summary
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
<div style="font-size:30px">'''EDATE(sd,m)'''</div><br/>
*where 's'd ts the starting date and 'm' is the number of months with '+' or '-'
==Description==
*This function gives the date that is mentioned number of months before or after a specified sd.
*In EDATE(sd, m) sd indicates the start date .
*Sd must be entered in DATE function format or we can entered with in double quotas(" ").
*For e.g EDATE("1/2/1990",2). m is represents the number of months before or after the start date.
*Suppose m is positive value then the function will display the after the sd or future date or m is negative value then the function will display the before the sd or past 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.
*This function will show the result as error when
#The sd is not a valid date,or it is not in the DATE function format.
#'M' is not an Integer.
==Examples==
#EDATE("1/1/1910",2)=Tue Mar 01 1910 00:00:00 GMT +0530 (Indian standard time)
#EDATE("5/4/1897",5)=Mon Tue 04 189700:00:00 GMT +0530 (Indian standard time)
#EDATE("11/31/1999",3)=Wed Mar 01 200000:00:00 GMT +0530 (Indian standard time)
#EDATE("6/6/1979",-2)=Fri Apr 06 197900:00:00 GMT +0530 (Indian standard time)
#EDATE("4/15/1950",-6)=Sat Oct 15 194900:00:00 GMT +0530 (Indian standard time)
==See Also==
*[[Manuals/calci/DATE | DATE ]]
*[[Manuals/calci/DATE360 | DATE360]]
*[[Manuals/calci/DATE360 | DATE360]]
*[[Manuals/calci/DATEVALUE | DATEVALUE]]
==References==
[http://en.wikipedia.org/wiki/Bessel_function| Bessel Function]