How to Add select a date option in the first column of Onedrive Excel sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2092778%22%20slang%3D%22en-US%22%3EHow%20to%20Add%20select%20a%20date%20option%20in%20the%20first%20column%20of%20Onedrive%20Excel%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2092778%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20tried%20multiple%20options%20to%20add%20a%20column%20in%20the%20OneDrive%20excel%20sheets%20but%20unable%20to%20do%20it%20it.%20I%20simply%20want%20to%20add%20date%20in%20first%20column%20that%20when%20a%20person%20clicks%20in%20a%20box%20a%20calendar%20should%20appear%20and%20he%2Fshe%20should%20select%20a%20date%20from%20it.%20Please%20let%20me%20know%20the%20procedure.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2092778%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2092893%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Add%20select%20a%20date%20option%20in%20the%20first%20column%20of%20Onedrive%20Excel%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2092893%22%20slang%3D%22en-US%22%3EHello%20Mohsin%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20I%20am%20understanding%20your%20question%20correctly%2C%20then%2C%20I%20believe%20you%20can%20add%20a%20column%20by%20right%20click%20---insert%20column%20and%20if%20you%20want%20to%20pick%20date%20in%20that%20column%20cell%2C%20for%20example%2C%20if%20you%20inserted%20column%20and%20the%20column%20is%20%22A%22%20and%20you%20want%20to%20select%20the%20date%20in%20%22A1%22%20cell.%20Then%20keep%20the%20cursor%20in%20A1%20and%20then%20select%20the%20date%20from%20your%20calendar.%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20get%20the%20ready%20made%20calendar%20---Very%20first%20open%20the%20one%20drive%20excel%20and%20see%20the%20developer%20tab%20if%20you%20don't%20have%20a%20developer%20tab%20in%20the%20home%20ribbon%2C%20then%20click%20on%20File----Option---Customize%20ribbon---click%20on%20the%20Developer%20and%20click%20ok---Developer%20tab%20will%20appear%20in%20home%20Ribbon.%3CBR%20%2F%3E%3CBR%20%2F%3ENow%20under%20the%20Developer%20click%20on%20----Add-ins%20button%20----(%20just%20note%3A-%20internet%20should%20be%20working%20at%20this%20time)-%20now%20you%20will%20see%20one%20window%20will%20appear%20with%20the%20name%20of%20Office%20add-%20ins---now%20in%20search%20box%20write%20datepicker%20(without%20space)%20and%20you%20will%20see%20mini%20calendar%20and%20date%20picker---just%20add%20that%20----%20and%20now%20keep%20the%20cursor%20where%20you%20want%20to%20select%20the%20date%20and%20click%20on%20date%20from%20the%20calendar%2C%20it%20will%20show%20from%20the%20same%20box----%3CBR%20%2F%3E%3CBR%20%2F%3ELet's%20see%2C%20if%20it%20works%20for%20you.%20----finger%20crossed.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2093071%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Add%20select%20a%20date%20option%20in%20the%20first%20column%20of%20Onedrive%20Excel%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2093071%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F929113%22%20target%3D%22_blank%22%3E%40getguidedlearning%3C%2FA%3E%26nbsp%3BYou%20did%20not%20understand%20my%20question%2C%20basically%20i%20want%20add%20a%20select%20date%20option%20in%20first%20column%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22TheMohsin_0-1611562565428.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F249072i34D26E1D2410F656%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22TheMohsin_0-1611562565428.png%22%20alt%3D%22TheMohsin_0-1611562565428.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EFor%20example%2C%20if%20a%20click%20on%20a%20column%2C%20it%20show%20a%20select%20date%20option.%20I%20would%20like%20to%20know%20the%20procedure.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2093716%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Add%20select%20a%20date%20option%20in%20the%20first%20column%20of%20Onedrive%20Excel%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2093716%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F941150%22%20target%3D%22_blank%22%3E%40TheMohsin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20wanted%20to%20check%2C%20do%20you%20want%20to%20see%20the%20date%20selection%20calendare%20option%20in%20each%20cell%20of%20%22A%22%20column.%3C%2FP%3E%3CP%3EIf%20yes-%20then%20solution%20will%20be%20something%20else.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20no-%20and%20you%20just%20want%20to%20see%20your%20%22A%22%20column%20date%20list%20in%20one%20singal%20cell%20and%20wants%20to%20select%20date%20from%20drop%20down%20than%26nbsp%3B%20Data%20Validation%20will%20work%20for%20you.%26nbsp%3B%20which%20will%20look%20something%20like%20the%20below.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22getguidedlearning_0-1611576698668.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F249102i01A1B8E4EC734D93%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22getguidedlearning_0-1611576698668.png%22%20alt%3D%22getguidedlearning_0-1611576698668.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EReally%20sorry%2C%20if%20my%20answer%20does%20not%20help%20you.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2093747%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Add%20select%20a%20date%20option%20in%20the%20first%20column%20of%20Onedrive%20Excel%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2093747%22%20slang%3D%22en-US%22%3EYes%2C%20I%20want%20to%20see%20date%20of%20each%20cell%20of%20column%20A%3C%2FLINGO-BODY%3E
New Contributor

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.

5 Replies
Hello Mohsin

If I am understanding your question correctly, then, I believe you can add a column by right click ---insert column and if you want to pick date in that column cell, for example, if you inserted column and the column is "A" and you want to select the date in "A1" cell. Then keep the cursor in A1 and then select the date from your calendar.

You can get the ready made calendar ---Very first open the one drive excel and see the developer tab if you don't have a developer tab in the home ribbon, then click on File----Option---Customize ribbon---click on the Developer and click ok---Developer tab will appear in home Ribbon.

Now under the Developer click on ----Add-ins button ----( just note:- internet should be working at this time)- now you will see one window will appear with the name of Office add- ins---now in search box write datepicker (without space) and you will see mini calendar and date picker---just add that ---- and now keep the cursor where you want to select the date and click on date from the calendar, it will show from the same box----

Let's see, if it works for you. ----finger crossed.





@getguidedlearning You did not understand my question, basically i want add a select date option in first column

TheMohsin_0-1611562565428.png

For example, if a click on a column, it show a select date option. I would like to know the procedure.

@TheMohsin 

 

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.

 

getguidedlearning_0-1611576698668.png

 

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..