| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the year only in a date
I have several dates in a worksheet (eg, "01/01/01; 01/02/03; 02/04/05"). I
want to change only the dates for 2005. Is there an automatic way to do this without going into each cell? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing the year only in a date
You could test each cell to see if it is greater than 12/31/04
Than do what ever you want to change it Excel sees 12/31/04 as 38352 Each day is = 1 If Cells(1, 1) 38352 Then MsgBox Range("a1").Value + 5 End If -- steveB Remove "AYN" from email to respond "cs_vision" wrote in message ... I have several dates in a worksheet (eg, "01/01/01; 01/02/03; 02/04/05"). I want to change only the dates for 2005. Is there an automatic way to do this without going into each cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine year over year date for comparison | Excel Worksheet Functions | |||
| Display date as 06/08 (m,yy) without year changing back to 07? | Excel Discussion (Misc queries) | |||
| changing the year of a date | Excel Worksheet Functions | |||
| a Month to Date and Year TD page in one sheet changing each day? | Excel Discussion (Misc queries) | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
Linear Mode
