Data Validation For Selecting Date And Week Number

is it possible to use a dropdown list with data validation. I want to use a dropdown list for the date and the week number works off the date
I added manually to show desired result......can dates also be entered using VBA
Thanks

see attched file sheet 1. see entries H1 I1 J1 K1
now see formula in I2 which is copied down and along columns for 7 rows.
now use dependent valiation based on these data.

Paul, Venkat has given you a solution the gives the 7 days of the Nth week, based on year. Does that solve your need? From what I understood, you just want a validation list from which you can select any day, and the week number of that day will display in the adjacent column. Is that correct?

Hi Excel Fox

I think the best solution would be for me to enter a date into cell C15 and then through VBA select a button and it inserts the dates through to 21/12/2013 using the pattern of dates in the file attached.The week numbers would also insert with VBA according to the date....I would also have a second button which deletes the dates but only after a password is entered........I would then change the code when this spreadsheet is used for 2014 onwards

Maybe you could also achieve this with a dropdown list (DV) which I would prefer but I do not know if achievable

Thanks Venkat

Thank you

Paul

I am assuming you mean 31st Dec 2013, and not 21st. And what do you mean by 'pattern of dates'?

still it is not clear what you want. if you want a vlidation list for each week number
see attached workbook(prev book is modified).
\
at first try this
in E1 chooe a weeknumber from validation list arrow. E1 will be filled
after fillig E1 click the validation arrow what do you get??????

do same experimet by choosing another weeknumber in E1 and see validation list for F1.

now how to get at it see the text box.

may be little complicated but you can do it. experient in ano ther file

why do you need a password.

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

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).

Hi

No that thread is not abandoned as there is more replies from me....That one is code and this one is preferably Data Validation...No harm meant and I see both the same threads here and then ask on other forums...is this an issue...it is all about learning....code, formula and DV has been learnt

Hope this has not offended anyone as this is not my intention

Paul