Need formula to calculate days between dates or back date

[KVN]

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?

[JMay]

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


"KVN" wrote:

> 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

[Jim May]

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


"JMay" wrote:

>
> 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
>
>
> "KVN" wrote:
>
> > 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