ExcelBanter - How do I subtract dates to get a number in years or years & month

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I subtract dates to get a number in years or years & month (https://www.excelbanter.com/excel-discussion-misc-queries/107131-how-do-i-subtract-dates-get-number-years-years-month.html)

jude

How do I subtract dates to get a number in years or years & month

Say I wanted to subtract 1/01/2005 from 6/30/2006 where I would get 1.5
years. Anybody know?

Barb Reinhardt

How do I subtract dates to get a number in years or years & month

How about

=(A2-A1)/365

And format to numeric.

"jude" wrote:

Say I wanted to subtract 1/01/2005 from 6/30/2006 where I would get 1.5
years. Anybody know?

Dave Peterson

How do I subtract dates to get a number in years or years & month

Chip Pearson has some very nice notes at:
http://www.cpearson.com/excel/datedif.htm

jude wrote:

Say I wanted to subtract 1/01/2005 from 6/30/2006 where I would get 1.5
years. Anybody know?

--

Dave Peterson

All times are GMT +1. The time now is 04:50 PM.