ExcelBanter - calculating periods (yrs, months and days)

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - calculating periods (yrs, months and days) (https://www.excelbanter.com/new-users-excel/243227-calculating-periods-yrs-months-days.html)

ROHIT

calculating periods (yrs, months and days)

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

Stefi

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

All times are GMT +1. The time now is 03:22 AM.