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