| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Aggregating months over periods | Excel Worksheet Functions | |||
| Calculating Months while taking into consideration days | Excel Worksheet Functions | |||
| problem of calculating years months and days | Excel Discussion (Misc queries) | |||
| FORMULA FOR CALCULATING YEARS, DAYS, & MONTHS BETWEEN SEVERAL DATE | Excel Discussion (Misc queries) | |||
| Calculating an Activities During Periods Of Natural Months and/or Dates | Excel Worksheet Functions | |||
Linear Mode
