Data Validation For Selecting Date And Week Number

[venkat1926]

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.