Data Validation For Selecting Date And Week Number

[paul_pearson]

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

[Rick Rothstein]

Except for the starting cell, this appears to be the identical question this OP posted here...

inserting date

And there are solutions there for part of his question over there... including from me. I'm guessing the OP abandoned the thread over there in order to pursue it here (if so... that was not a very nice thing to do).