Difference between revisions of "Manuals/calci/DAYSBETWEEN"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
==See Also== | ==See Also== | ||
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/DAYS360 | DAYS360]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/DATE | DATE]] |
| + | *[[Manuals/calci/DAYS | DAYSE]] | ||
==References== | ==References== | ||
[http://en.wikipedia.org/wiki/Complex_number| Complex Numbers] | [http://en.wikipedia.org/wiki/Complex_number| Complex Numbers] | ||
Revision as of 04:25, 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