Datedif

[Muchemi]

=IF(H5="","",IF(F5<H5,DATEDIF(H5,F5,"d"),-1*DATEDIF(F5,H5,"d")))
Iam trying this formula to get days difference between two dates, so far its working but when date 2 is less than date 1 error occurs,

kindly help

 

[pecoflyer]

The syntax is DATEDIF(start_date,end_date,"d")
=IF(H5="","",IF(F5<H5,DATEDIF(F5,H5,"d"),DATEDIF(H5,F5,"d")))
(I don't know what the -1 is for in your example)

 

[Chihiro]

If it's number of days. You can just use subtraction. As Excel stores dates in integer value.

DATEDIF is only needed for weeks or months difference.

Ex: =F5 - H5

If you don't want the negative difference, you can always nest it in ABS().

 

[Muchemi]

Pecoflyer Iam using the formula You gave and is still throwing the error

 

[pecoflyer]

Post a small sample sheet please

 

[Muchemi]

the problem is in that sample sheets if date came is less or greater than scheduled there is a error

 

[bosco_yip]

the problem is in that sample sheets if date came is less or greater than scheduled there is a error

Try,

In C2, formula copied down :

=IF(A2="","",IF(B2<A2,A2-B2,B2-A2))

Regards