| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change the year in employee absence schedule
Is there a way to change the year for the employee absence schedule, without
manually changing each month? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change the year in employee absence schedule
Select the column(A) with the dates and EditReplace
what: 2005 with: 2006 Why would this be a suggestion for Microsoft? Gord Dibben MS Excel MVP On Wed, 23 Aug 2006 11:18:02 -0700, Vicki wrote: Is there a way to change the year for the employee absence schedule, without manually changing each month? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change the year in employee absence schedule
Will this automatically change the day and date?
"Gord Dibben" wrote: Select the column(A) with the dates and EditReplace what: 2005 with: 2006 Why would this be a suggestion for Microsoft? Gord Dibben MS Excel MVP On Wed, 23 Aug 2006 11:18:02 -0700, Vicki wrote: Is there a way to change the year for the employee absence schedule, without manually changing each month? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change the year in employee absence schedule
In this Template...........No, because the day and date are hard-wired.
http://office.microsoft.com/en-us/te...172961033.aspx You will have make those changes manually A good sugestion to Microsoft would be to update the Template to 2006 with all attendant changes. Gord On Wed, 23 Aug 2006 12:13:02 -0700, Vicki wrote: Will this automatically change the day and date? "Gord Dibben" wrote: Select the column(A) with the dates and EditReplace what: 2005 with: 2006 Why would this be a suggestion for Microsoft? Gord Dibben MS Excel MVP On Wed, 23 Aug 2006 11:18:02 -0700, Vicki wrote: Is there a way to change the year for the employee absence schedule, without manually changing each month? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| holiday dates | Excel Worksheet Functions | |||
| Employee Work Schedule | Excel Discussion (Misc queries) | |||
| How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
| Employee schedule: I want it to calculate time entered such as 11. | Excel Discussion (Misc queries) | |||
| Employee Shift Schedule Excel template | Excel Discussion (Misc queries) | |||
Hybrid Mode
