| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract Years
=YEAR(B1)-A1
B1=Date ....04/06/1999 A1=year ....1971 Format cell as general "Karl" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtract Years
See if this works:
=YEAR(B1)-A1 Where B1 is your sample date, and A1 is your origin year. Make sure to format the cell you place the formula in as a number (or General) and not a date. HTH, Elkar "Karl" wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
