| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add one year to dates
I would like to add one year to all dates in a spreadsheet (2006 to 2007.)
There are no dates in calculations. Thank you in advance for any replies. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add one year to dates
Try this:
Select the range containing the dates From the Excel main menu: <edit<replace Find what: 2006 Replace with: 2007 Click the [Replace All] button Does that help? *********** Regards, Ron XL2002, WinXP "Lee D" wrote: I would like to add one year to all dates in a spreadsheet (2006 to 2007.) There are no dates in calculations. Thank you in advance for any replies. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add one year to dates
That was too easy...isn't there a more complicated solution? ;)
Thank you "Ron Coderre" wrote: Try this: Select the range containing the dates From the Excel main menu: <edit<replace Find what: 2006 Replace with: 2007 Click the [Replace All] button Does that help? *********** Regards, Ron XL2002, WinXP "Lee D" wrote: I would like to add one year to all dates in a spreadsheet (2006 to 2007.) There are no dates in calculations. Thank you in advance for any replies. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add one year to dates
Of course, Lee!.....there's ALWAYS a more complicated solution. In fact, I've
worked with several people who had a natural talent for finding unduly complicated solutions. <vbg ....and thanks for the feedback...I'm glad I could help. *********** Regards, Ron XL2002, WinXP "Lee D" wrote: That was too easy...isn't there a more complicated solution? ;) Thank you "Ron Coderre" wrote: Try this: Select the range containing the dates From the Excel main menu: <edit<replace Find what: 2006 Replace with: 2007 Click the [Replace All] button Does that help? *********** Regards, Ron XL2002, WinXP "Lee D" wrote: I would like to add one year to all dates in a spreadsheet (2006 to 2007.) There are no dates in calculations. Thank you in advance for any replies. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| dates in year | Excel Worksheet Functions | |||
| How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
| How can I hide points for future dates on a Year to Date chart? | Charts and Charting in Excel | |||
Linear Mode
