How to create date drop down list in each cell

Hi,
plz find attachment.
 

Attachments

  • calendar drop down list.xlsx
    8.7 KB · Views: 21
Thank you Sambit, however, i think this will need to make a list of dates within the year because when you are in December you must as well have the December dates which means that you have to go further downward in the drop down list to find the December dates.. I thought there is a simple way just to click the right arrow to switch the months within the dates and then simply select the date you need. however, I have been able to do this in only one cell, therefore i wanted to create a calender date picker in each cell so as to simply pick the date from the list.
 
Back
Top