| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtract Years
Hello,
In one column I have the year a forest originated in number format (i.e. 1971). In another column I have the date the forest was sampled in date format (i.e. 04/06/1999). I want to subtract the two so I know how old the forest was when it was sampled. (I.e. 1999-1971). However, because the two are in different formats I'm finding this impossible. Any advice would be greatly appreciated. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtract years and months (as in ages) from another age | Excel Discussion (Misc queries) | |||
| How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
| To create formula to add 3 years and subtract 1 day from a date? | Excel Worksheet Functions | |||
| How do I subtract a date from a date for a sum of total years? | Excel Discussion (Misc queries) | |||
| how do I subtract years and then divide | Charts and Charting in Excel | |||
Threaded Mode
