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

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

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

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