| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates
I have dates that are the same in each month ex.
04/15/2007 04/19/2007 04/25/2007 When april is over how can i just change the month to may and still have the same days |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates
If the dates are in, say column A, then in a helper column enter:
=DATE(2007,5,DAY(A1)) and copy down. If you can't use a helper column, then in an un-used cell enter 30. Copy that cell and paste/special/add onto the April dates. Then change the format back to date. -- Gary''s Student - gsnu200714 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates
One way:
Choose Edit/Replace... Find: 04/ Replace with: 05/ However, you should note that replacing the 05/ in 05/31/2007 with 06/ will convert the entry to Text, since 06/31/2007 isn't a valid date. You don't say how you'd want to handle that. In article , dar wrote: I have dates that are the same in each month ex. 04/15/2007 04/19/2007 04/25/2007 When april is over how can i just change the month to may and still have the same days |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates
You could use a formula like this to display your dates:
=DATE(2007,Z1,15) Where the number of the month is stored in a out of the way cell (4 in Z1). Then, just change the value in that cell whenever you wish to change all the date cells that have this formula. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "dar" wrote in message ... I have dates that are the same in each month ex. 04/15/2007 04/19/2007 04/25/2007 When april is over how can i just change the month to may and still have the same days |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates
When i type that in with edit/and paste it had an error message that says it
can not find the data even though i have hi-lighted it "JE McGimpsey" wrote: One way: Choose Edit/Replace... Find: 04/ Replace with: 05/ However, you should note that replacing the 05/ in 05/31/2007 with 06/ will convert the entry to Text, since 06/31/2007 isn't a valid date. You don't say how you'd want to handle that. In article , dar wrote: I have dates that are the same in each month ex. 04/15/2007 04/19/2007 04/25/2007 When april is over how can i just change the month to may and still have the same days |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
| Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel | |||
Linear Mode
