Just had a thourght.

Can you have mondays date of that week put into the first row as soon
as the file is opened that week?

I could then have it work out the rest of the week.

cheers

Ian


--
cs2883
------------------------------------------------------------------------
cs2883's Profile: http://www.excelforum.com/member.php...o&userid=27888
View this thread: http://www.excelforum.com/showthread...hreadid=473918