Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Date
I have a sheet that has a column with the date. I need to change that date
to the next day. Is there an easy way to do this? I don't want to have to retype each date. Thanks. I am using the format 7/12/07 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Date
well, it can be easy depending on how you're doing it.
If you want: 7/12/07 7/13/07 7/14/07 etc. Then, type in he first two dates, then highlight those two cells.. hover over the bottom right edge of the select box until your cursor looks like a plus sign. Click and drag til you have all the dates you need Or, type in the first date, go to the new row, type =A1 (assuming first date was in A1), then copy and paste this cell down your rows "Denise" wrote: I have a sheet that has a column with the date. I need to change that date to the next day. Is there an easy way to do this? I don't want to have to retype each date. Thanks. I am using the format 7/12/07 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Date
Nope this won't work. I have 20-30 days that are 6/1/07, 6/2/07, etc.
"Sean Timmons" wrote: well, it can be easy depending on how you're doing it. If you want: 7/12/07 7/13/07 7/14/07 etc. Then, type in he first two dates, then highlight those two cells.. hover over the bottom right edge of the select box until your cursor looks like a plus sign. Click and drag til you have all the dates you need Or, type in the first date, go to the new row, type =A1 (assuming first date was in A1), then copy and paste this cell down your rows "Denise" wrote: I have a sheet that has a column with the date. I need to change that date to the next day. Is there an easy way to do this? I don't want to have to retype each date. Thanks. I am using the format 7/12/07 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Date
Format a cell as date (this is important or else you have to reformat all
your dates after pasting), put 1 in that cell, copy that cell, select all dates and do editpaste special and select add, that will add one day to each of those dates -- Regards, Peo Sjoblom "Denise" wrote in message ... Nope this won't work. I have 20-30 days that are 6/1/07, 6/2/07, etc. "Sean Timmons" wrote: well, it can be easy depending on how you're doing it. If you want: 7/12/07 7/13/07 7/14/07 etc. Then, type in he first two dates, then highlight those two cells.. hover over the bottom right edge of the select box until your cursor looks like a plus sign. Click and drag til you have all the dates you need Or, type in the first date, go to the new row, type =A1 (assuming first date was in A1), then copy and paste this cell down your rows "Denise" wrote: I have a sheet that has a column with the date. I need to change that date to the next day. Is there an easy way to do this? I don't want to have to retype each date. Thanks. I am using the format 7/12/07 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) |