calculating periods (yrs, months and days)

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
 
S

Stefi

01/08/09 being in A1:

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

Regards,
Stefi

„Rohit†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Count dates within a Month 4
Calculate duration (#yrs., # mos.) 2
mortgage payment calculation 12
Calculating Months within a specific period 6
Repaymen of loan excel sheet with grace period etc... 14
Date Calculation - Astro Calculation 2
Filter duplicates by multiple criteria 1
Return Max Date 1

Top