Manuals/calci/DAYSBETWEEN

Revision as of 20:32, 24 October 2013 by MassBot1 (talk | contribs) (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 /> ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
 

DAYSBETWEEN( First date, Second date)



 

This function calculates the number of days between two particular dates.


DAYSBETWEEN


 

Lets see an example,


DAYSBETWEEN( First date, Second date)


B


01-01-2008


25-12-2008


DAYSBETWEEN(B2,B3)


=DAYSBETWEEN(First date, Second date) is 743


Syntax

Examples

Description

Column1 Column2 Column3 Column4
Row1 01-01-2008
Row2 25-12-2008
Row3 743
Row4
Row5
Row6