There is a function called WEEKDAY, if there is only 1 parameter, such
as WEEKDAY(A2), it will return a number coresponding to a day of the
week (i believe 1 is sunday and 7 is saturday). I never played around
with the other parameters, but I think they alter the starting of the
numbering (ie make wednesday 1)


--
davideggy
------------------------------------------------------------------------
davideggy's Profile: http://www.excelforum.com/member.php...o&userid=25239
View this thread: http://www.excelforum.com/showthread...hreadid=386882