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

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?


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=538638

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

Or try this (modification) - it figures if dates are out-of-order...
=IF(B7A7,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