calculating periods (yrs, months and days)

  • Thread starter Thread starter Rohit
  • Start date Start date
R

Rohit

Hi

I need a formula to calculate the date 4.78 yrs back from 01/08/09. i
manually did which is 20/10/04. any help
 
01/08/09 being in A1:

=A1-4.78*365-INT(4.78/4)

Regards,
Stefi

„Rohit†ezt írta:
 
Back
Top