Hi
Thanks for this. It works by bringing through the date of week commencing, what I am wanting to do is on the SOW sheet where it brings in the date for each session, I want the appropriate date if that makes sense so that if a session is monday and thursday the second session date shows as thursday rather than the monday date.
Also 05/09/11 is a monday but excel says it is a sunday.

Terri