As a huge user of Excel, I am often entering dates into cells. Different versions of Microsoft have had date pickers as an optional add on, but they haven’t always worked for me with all versions or consistently.
I have however just discovered this free tool:
http://samradapps.com/datepicker/
Which is created by Sam Radakovitz , which does exactly what I want.
Once set up, if a cell in Excel is set as a date, clicking on that cell, will bring up a small calendar icon to the right of the cell:
Which when clicked on, will bring up the calendar tool, making it easier to enter dates, and not have to worry about the correct format, or whether the spreadsheet has been set up in UK or USA format.
Full credit to Sam for this one, I am just blogging about this mainly for my own benefit so that I can relocate this in the future when I change computers.
Filed under: CPD and reflective practice, Excel, How do I...?, Office 365 | Tagged: Date, Excel, free, insert, Microsoft, Picker, tool | Leave a comment »