Employee Absence Schedule for 2007?

[Guest]

I've downloaded this from MS's Templates site
http://office.microsoft.com/en-us/templates/TC061172961033.aspx?CategoryID=CT063469961033
But it is for 2005! Does anyone know how I can do exactly this sheet
for 2007 please?

Thanks,
Dave

 

[smw226 via OfficeKB.com]

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

 

[smw226 via OfficeKB.com]

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

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/templates/TC061172961033.aspx?CategoryID=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.aspx/ms-excel/200611/1

 

[Guest]

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

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

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/templates/TC061172961033.aspx?CategoryID=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.aspx/ms-excel/200611/1