Calculating date in Decimal

[ace_friends22]

Hi Team,

I am trying to calculate date as below.

E5 = 11/1/2010
C5 = =CONCATENATE(YEAR(TODAY()) - YEAR(E5), " Years")

It shows result : 2 years... but i want it in decimal format... i.e. 1.10 years...

Can someone help me on how to achieve this?

[RichMelbourne]

Try:

=ROUND((({Todays Date}-{Date you want to calculated years since})/365),2)


The final 2 is the number of decimal places you want it to calculate to, not necessarily what will be displayed.

RIch

[Richard Buttrey]

Why 1.1?

Is 11/1/2010 the 11th January 2010 or 1st November 2010?

In either case the year for E5 is 2010, and the year for today is 2012. Hence 2012-2010 = 2