Hi Excel Fox

Yes 31st Dec 2013...the dates are for Monday to Friday (no weekends)...There are 3 empty cells between the last date of the week to the first date of the next week

Hi Venkat
Thanks...I am about to look at your file now..thanks

Paul