Month calculate from a date in point

[sa.1985]

Dear all,


I have a date 1-jan-2010

i want to calculate month, day and year till today from above date ,

i want to result in point means 1 and half = 1.6

 

[senthilkumar_rm]

Hi Sa


Try this


=(TODAY()-H17)/365


H17 = Select your cell which has your date

 

[Faseeh]

Hi sa.1985,


..Besides senthilkumar_rm's formula for Years, you can use:

=MOD(B1,1)*12 For Months,`

=MOD(C1,1)*30

For Days,`


where as B1 has Years calculated by senthilkumar_rm's formula and C1 contains months calculated by above formula.


Regards,

Faseeh