| Home |
| Search |
| Today's Posts |
|
#1
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate dates | Excel Worksheet Functions | |||
| To Calculate the qty b/w two dates | Excel Worksheet Functions | |||
| How can I calculate dates? | New Users to Excel | |||
| Calculate dates | Excel Worksheet Functions | |||
| How do I calculate dates? | Excel Worksheet Functions | |||
Linear Mode
