Manuals/calci/DAYSBETWEEN

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

See Also

• DAYS360
• DATE
• DAYSE

References

Complex Numbers