Thread: calculating periods (yrs, months and days)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default calculating periods (yrs, months and days)
01/08/09 being in A1:

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

Regards,
Stefi

€˛Rohit€¯ ezt Ć*rta:

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
Reply With QuoteReply With Quote