| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Start Date minus (Years + Months + Days) = ?
In Excel, suppose I have a regular date, like: 3 February 1922
Now, I want to subtract: 86 years, 6 months, and 23 days. 1) How can I do this in a formula? 2) What is the correct answer? 3) What are the limitations in Excel for this type of calculation? Thanks much in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting days to years & months & days | Excel Discussion (Misc queries) | |||
| how do i convert a number of days to years, months & days? | Excel Discussion (Misc queries) | |||
| HOW DO I CALCULATE THE YEARS MONTHS AND DAYS BETWEEN SEVERAL DATE | Excel Discussion (Misc queries) | |||
| FORMULA FOR CALCULATING YEARS, DAYS, & MONTHS BETWEEN SEVERAL DATE | Excel Discussion (Misc queries) | |||
| convert Days to Years, Months, Days | Excel Discussion (Misc queries) | |||
![quartz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
