date time

[pmratlam]

i m an accountant in a office
i want to calculate day, month and year between a specific dates

ex
how many day, month and year between 1/1/2000 to 5/7/2004

plz help

[arthurbr]

Try

Please Login or Register  to view this content.

were A1 = start date and B1=end date

[WinteE]

Try the following formula :

=ROUND.DOWN((B1-A1)/365;0) & " years, " & ROUND.DOWN(MOD((B1-A1);365)/30;0) & " months, " & (B1-A1)-(ROUND.DOWN((B1-A1)/365;0)*365)-(ROUND.DOWN(MOD((B1-A1);365)/30;0)*30) & " days"

As I'm using a Dutch Office version I translated it manually. he ROUND.DOWN might be without a dot.

Success

[arthurbr]

WinteE

for your info the Dutch equivalent of DATEDIF is DATUMVERSCHIL

Though it still works it is not documented in XL help anymore since XL2000 ( I believe)

[WinteE]

Thanks arthurbr !