| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
date range conversion
Hello,
I need to convert dates ranging from 1999 through 2004 to 2005 dates. Can this be done????? thanks..... Example, A1 B2 01/05/1999 01/05/2005 03/18/2003 03/18/2005 09/01/2002 09/01/2005 |
|
#2
|
|||
|
|||
|
=date(2005,month(a1),day(a1))
will work for almost every date--except for Feb 29, 2004. tssjhs wrote: Hello, I need to convert dates ranging from 1999 through 2004 to 2005 dates. Can this be done????? thanks..... Example, A1 B2 01/05/1999 01/05/2005 03/18/2003 03/18/2005 09/01/2002 09/01/2005 -- Dave Peterson |
|
#3
|
|||
|
|||
|
Just another way:
=--(TEXT(A1,"m/d/")&"05") Format the formula cell as date. HTH Jason Atlanta, GA -----Original Message----- Hello, I need to convert dates ranging from 1999 through 2004 to 2005 dates. Can this be done????? thanks..... Example, A1 B2 01/05/1999 01/05/2005 03/18/2003 03/18/2005 09/01/2002 09/01/2005 . |
|
#4
|
|||
|
|||
|
Thanks Guys, it worked perfectly...
"tssjhs" wrote: Hello, I need to convert dates ranging from 1999 through 2004 to 2005 dates. Can this be done????? thanks..... Example, A1 B2 01/05/1999 01/05/2005 03/18/2003 03/18/2005 09/01/2002 09/01/2005 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Conversion | Excel Discussion (Misc queries) | |||
| Completion Percentage of a date range | Excel Discussion (Misc queries) | |||
| unwanted number to date conversion while pasting data from web | Excel Worksheet Functions | |||
| SUMPRODUCT with date range question | Excel Discussion (Misc queries) | |||
| How can I sum information in a list with a date range? | Excel Worksheet Functions | |||
Linear Mode
