Do you mean you want to know whether 1st July is a Monday, Tuesday
etc.?

you could use this formula

=TEXT(DATE(2006,7,1),"dddd")

or just put the date in a cell and format that cell as dddd


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=523259