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