00:00It's so unbelievably easy to add small pop-up clickable calendar in Google Sheet
00:05like this. All you have to do is select the cells that you want to add a
00:10calendar to like this. Then you go to data, data validation, a window will appear
00:16on the far right hand side. Click on add rules and in criteria you're gonna be
00:21selecting is valid date and normally I like to put reject the inputs if you put
00:26a dodgy date and then click on done and let's close this pop-up window here or
00:31the windows on the right hand side. Now if you go and click on any cell that you
00:35have selected for the date, double click on it, a pop-up window will appear just like
00:40this. If you want to add a clickable calendar in an individual cell, let's say
00:45for example here, all you have to do is type the word ampersand and type date in
00:50there and then from this pop-up window you're gonna select date and now you can
00:54select the date and if you go back to the date and double click on it you can see
00:59that the calendar appears
Comments