Forum Discussion
How to Add select a date option in the first column of Onedrive Excel sheets
getguidedlearning You did not understand my question, basically i want add a select date option in first column
For example, if a click on a column, it show a select date option. I would like to know the procedure.
Just wanted to check, do you want to see the date selection calendare option in each cell of "A" column.
If yes- then solution will be something else.
If no- and you just want to see your "A" column date list in one singal cell and wants to select date from drop down than Data Validation will work for you. which will look something like the below.
Really sorry, if my answer does not help you.
- Yes, I want to see date of each cell of column A
TheMohsin Hi Mohsin
Here is the solution for picking date through calendar and date calendar will show in each cells. -
Please follow the process in attached SOP..