Need formula to calculate days between dates or back date

[Guest]

I need a formula to calculate days between dates if before each other i.e.

18 Apr & 9 Apr = - 9 days

I can calculate the difference for say
13 Mar & 18 Apr = 36 days
but need a formulae to calculate both in a list
Col 1 col 2 col 3
13 Mar 18 Apr 36
18 Apr 9 Apr ?
3 Mar 30 Mar 27

Thanks any help would be appreciated

 

[Vito]

Why doesn't =B1-A1 work, where B1 contains Apr-9 and A1 contains
Apr-18?

Are your dates formatted as Dates? Or are they just text?

 

[Guest]

Try =DATEDIF(A7,B7,"d") - where A7 is your earlier date cell and
B7 is your later dates cell - First date must always be first (in order).
HTH

 

[Guest]

Or try this (modification) - it figures if dates are out-of-order...
=IF(B7>A7,DATEDIF(A7,B7,"d"),DATEDIF(B7,A7,"d"))