Display date differential as Years, Months and Days

[Gary McMaster]

Hi Everyone,

Although it may not be the best way, I believe the formulas shown below return the correct number of years and months. Is there a simple way to return the number of days? Given leap years and non-30 day months, I'm sure cell D2 is way wrong.

Best regards,

Gary

Sheet2

*	A	B	C	D
1	Days	Years	Months	Days
2	3804	10	5	4

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula A2 =DATEDIF("1/17/2005",NOW(),"D") B2 =DATEDIF("1/17/2005",NOW(),"y") C2 =(DATEDIF("1/17/2005",NOW(),"m")-(12*B2)) D2 =A2-((365*B2)+(30*C2)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[James006]

Hi,

As far as Datedif() is concerned ... you could use "ym" as argument for cell C2 and "md" for cell D2 ...

 

[Gary McMaster]

Perfect. Thanks very much James

 

[James006]

Glad this could help ...

Thanks for the feedback ...