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
• DAY