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. |
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. |
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. |
All times are GMT +1. The time now is 11:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com