Pre Populate Date

Hi all, assistance appreciated, thanks in advance..

I have a need to prepopulate a series of work sheets with dates aligned to days of the week

I know the Year, Month, Day, Week number

Cant seem to get my head around what I am sure is an easy formulae

Cheers

scowan