You can use the 2nd argument of the Weekday function

WEEKDAY(serial_number,return_type)

Return_type
1 or omitted Numbers 1 (Sunday) through 7 (Saturday)
2 Numbers 1 (Monday) through 7 (Sunday)
3 Numbers 0 (Monday) through 6 (Sunday)

Cheers
Andy

Bob Phillips wrote:
Note that weekday returns 1-7 not 0-6.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info