The only way I know would be to make seperate table with a list of the
week numbers and the dates for each week and then use a lookup to check
for the value to be entered in your main table.

But I dont know much about Excel and there is proberbly a better way so
I would wait for one of the others to see what they say.


--
johneva
------------------------------------------------------------------------
johneva's Profile: http://www.excelforum.com/member.php...o&userid=34156
View this thread: http://www.excelforum.com/showthread...hreadid=539216