Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Employee Absence Schedule for 2007?
I've downloaded this from MS's Templates site;
http://office.microsoft.com/en-us/te...CT063469961033 But it is for 2005! :( Does anyone know how I can do exactly this sheet for 2007 please? Thanks, Dave |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Employee Absence Schedule for 2007?
Hi Dave
If you change the "January 2005" to 01/01/2007 (you can format the cell to mmmm yyyy) for every month and paste the below into the Day identifier =LOOKUP(WEEKDAY(B4&MID($A2,3,8),1),{1,2,3,4,5,6,7} ,{"S","M","T","W","T","F", "S"}) then drag the forumla accross for every day. HTH Simon Horrgakx wrote: I've downloaded this from MS's Templates site http://office.microsoft.com/en-us/te...CT063469961033 But it is for 2005! :( Does anyone know how I can do exactly this sheet for 2007 please? Thanks, Dave -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Employee Absence Schedule for 2007?
Sorry Dave,
you will have to format the date as text and not date so you can not format to mmmm yyyy.... I wrote this in 2007 and it works, but it doesn't in 2003. Thanks, Simon smw226 wrote: Hi Dave If you change the "January 2005" to 01/01/2007 (you can format the cell to mmmm yyyy) for every month and paste the below into the Day identifier =LOOKUP(WEEKDAY(B4&MID($A2,3,8),1),{1,2,3,4,5,6,7 },{"S","M","T","W","T","F", "S"}) then drag the forumla accross for every day. HTH Simon I've downloaded this from MS's Templates site http://office.microsoft.com/en-us/te...CT063469961033 [quoted text clipped - 3 lines] Thanks, Dave -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200611/1 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Employee Absence Schedule for 2007?
Thansk for the reply, I appreciate that.
It is over my head though and will probably take longer than for me just to work out the dates and manually enter them. I'd hoped an up to date template may have existed. Not to worry ;) "smw226 via OfficeKB.com" wrote: Sorry Dave, you will have to format the date as text and not date so you can not format to mmmm yyyy.... I wrote this in 2007 and it works, but it doesn't in 2003. Thanks, Simon smw226 wrote: Hi Dave If you change the "January 2005" to 01/01/2007 (you can format the cell to mmmm yyyy) for every month and paste the below into the Day identifier =LOOKUP(WEEKDAY(B4&MID($A2,3,8),1),{1,2,3,4,5,6,7 },{"S","M","T","W","T","F", "S"}) then drag the forumla accross for every day. HTH Simon I've downloaded this from MS's Templates site http://office.microsoft.com/en-us/te...CT063469961033 [quoted text clipped - 3 lines] Thanks, Dave -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200611/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
employee schedule | Excel Discussion (Misc queries) | |||
change the year in employee absence schedule | Excel Worksheet Functions | |||
Employee Absence Schedule Template | Excel Discussion (Misc queries) | |||
Change the Employee Absence schedule template to 2006? | Excel Worksheet Functions | |||
Referencing a newly created worksheet | Excel Worksheet Functions |