How to get the value 30 as per the example?

[Trish]

Hi All,

I have two cells having dates 30/6/07 & 31/5/07. I need the difference (no.
of days) between these two days in a cell. Always I am getting the cell
value in date format. How to get the value 30 as per the above example?

Thanks for any replies.

Trish

 

[Pegasus \(MVP\)]

Hi All,

I have two cells having dates 30/6/07 & 31/5/07. I need the difference
(no.
of days) between these two days in a cell. Always I am getting the cell
value in date format. How to get the value 30 as per the above example?

Thanks for any replies.

Trish

Presumably you're talking about Excel, even though you
never say so. If so then you should post your question in
an Excel newsgroup.

 

[Gord Dibben]

Assuming you are running MS Excel you would have been better off posting to one
of the Excel groups.

But since I'm here I'll give you a formula.

With earliest date in A2 and later date in A3 enter this in a cell.

=DATEDIF(A2,A3,"d") returns 30 with your example data.

To expand if you want years, months, days for longer periods.

=DATEDIF(A2,A3,"y") & "years," & DATEDIF(A2,A3,"ym") & "months,"&
DATEDIF(A2,A3,"md") & "days,"

DATEDIF function is undocumented in all versions of Excel except XL2000


Gord Dibben MS Excel MVP