Forum Discussion
Solved
Excel Dates drop down list by weeks
Hi Is there any way to to create a drop down list linked to a week number Example. below. Any simple solutions welcomed and i will be grateful for some tips in colums A : I choose a financi...
Aga_112 In the attached I started something. I used 2 helper columns for the data validation lists for the years and the days of the intended week. You may want to tweak the data validation rules, warnings and alerts and such. I also don't know your Fiscal Yr cycle so made the assumption based on the example it starts on the Friday before April 1
Aga_112 In the attached I started something. I used 2 helper columns for the data validation lists for the years and the days of the intended week. You may want to tweak the data validation rules, warnings and alerts and such. I also don't know your Fiscal Yr cycle so made the assumption based on the example it starts on the Friday before April 1
