Difference between revisions of "Manuals/calci/DAYSBETWEEN"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font face="Arial, sans-serif"><font size="2">'''DAYSBETWEEN( First date, Second date)'''</font></font> <br /> ...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''DAYSBETWEEN(fd,sd)'''</div><br/> |
| − | + | *where 'fd' is the starting date and 'sd' is the second (final )date | |
| − | + | ==Description== | |
| + | *This function gives the number of days between the first date and the second date(30 days in 12 months). | ||
| + | *Here FD and SD are two dates to find the number of in between days. | ||
| + | *Also FD and SD we have to give in DATE function format. | ||
| − | + | ==Examples== | |
| − | |||
| − | |||
| − | + | *DAYSBETWEEN("2/28/2008","3/13/2008")=15 | |
| + | *DAYSBETWEEN("1-Sep-2014","1-Sep-2015")=366 | ||
| − | + | ==See Also== | |
| − | |||
| − | |||
| − | + | *[[Manuals/calci/COLUMNS | COLUMNS]] | |
| + | *[[Manuals/calci/ROW | ROW]] | ||
| − | + | ==References== | |
| − | + | [http://en.wikipedia.org/wiki/Complex_number| Complex Numbers] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
| − | |||
| − | |||
| − | |||
Revision as of 03:21, 15 November 2013
DAYSBETWEEN(fd,sd)
- where 'fd' is the starting date and 'sd' is the second (final )date
Description
- This function gives the number of days between the first date and the second date(30 days in 12 months).
- Here FD and SD are two dates to find the number of in between days.
- Also FD and SD we have to give in DATE function format.
Examples
- DAYSBETWEEN("2/28/2008","3/13/2008")=15
- DAYSBETWEEN("1-Sep-2014","1-Sep-2015")=366