Prev: Specific Date from a Range
Next: Removal of 100's of spacing in numbers
From: NINA on 29 Mar 2010 09:21
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
From: Bob Phillips on 29 Mar 2010 09:25
Either

=2010-LEFT(A1,4)

or

=2010-LEFT(A1,4)-1

depending on whether a part year counts

--

HTH

Bob

"NINA" <NINA(a)discussions.microsoft.com> wrote in message
news:BF88CAAF-5C13-43BE-816E-90ACFB9496B0(a)microsoft.com...
> 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


From: Faraz Ahmed Qureshi on 29 Mar 2010 09:26
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
 | 
Pages: 1
Prev: Specific Date from a Range
Next: Removal of 100's of spacing in numbers