|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 29th, 2010, 02:21 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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 
|
|
#2
March 29th, 2010, 02:25 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#3
March 29th, 2010, 02:26 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
