writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 16:
Line 16: + + Line 61:
Line 63: +
no edit summary
*<math>SD</math> date should be < <math>ED</math>, else Calci displays NaN error message.
*<math>SD</math> date should be < <math>ED</math>, else Calci displays NaN error message.
*<math>basis</math> value is optional. If omitted, Calci assumes it to be 0.
*<math>basis</math> value is optional. If omitted, Calci assumes it to be 0.
*We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
Below table shows the use of <math>basis</math> values:
Below table shows the use of <math>basis</math> values:
=DAYSBETWEENBASIS(DATE(2014,1,1),DATE(2014,4,1)) : Calculates the days between the dates mentioned. <br/>Returns '''90''' as a result.
=DAYSBETWEENBASIS(DATE(2014,1,1),DATE(2014,4,1)) : Calculates the days between the dates mentioned. <br/>Returns '''90''' as a result.
=DAYSBETWEENBASIS(DATE(2014,1,1),DATE(2015,4,1)) : Calculates the days between the dates mentioned. <br/>Returns '''450''' as a result.
=DAYSBETWEENBASIS(DATE(2014,1,1),DATE(2015,4,1)) : Calculates the days between the dates mentioned. <br/>Returns '''450''' as a result.
=DAYSBETWEENBASIS("17/6/2004[DD/MM/YYYY]","21/5/2006[DD/MM/YYYY]")= 694
==Related Videos==
==Related Videos==