ExcelBanter - Calculate Dates

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

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

- - Calculate Dates (https://www.excelbanter.com/excel-discussion-misc-queries/260145-calculate-dates.html)

Nina

Calculate Dates

Source Data coming in this format 19880716 would like to calculate the
difference in years between the source data date and the date 01/01/2010. How
would I write this formula. Appreciate anyone help--
NINA

Bob Phillips[_4_]

Calculate Dates

Either

=2010-LEFT(A1,4)

or

=2010-LEFT(A1,4)-1

depending on whether a part year counts

--

HTH

Bob

"NINA" wrote in message
...
Source Data coming in this format 19880716 would like to calculate the
difference in years between the source data date and the date 01/01/2010.
How
would I write this formula. Appreciate anyone help--
NINA

Faraz Ahmed Qureshi

Calculate Dates

Assuming the 19880716 to be in Cell A1, use:
=2010-left(A1,4)
--
Thanx & Best Regards,

Faraz!

"NINA" wrote:

Source Data coming in this format 19880716 would like to calculate the
difference in years between the source data date and the date 01/01/2010. How
would I write this formula. Appreciate anyone help--
NINA

All times are GMT +1. The time now is 08:32 PM.