Jan 24 2021 09:59 PM
I've tried multiple options to add a column in the OneDrive excel sheets but unable to do it it. I simply want to add date in first column that when a person clicks in a box a calendar should appear and he/she should select a date from it. Please let me know the procedure.
Jan 24 2021 11:13 PM
Jan 25 2021 12:17 AM
@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.
Jan 25 2021 04:14 AM
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.
Jan 25 2021 04:28 AM
Jan 25 2021 07:53 AM
@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..