Adding a date picker to Excel

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:

Image showing the calendar icon to right of the selected 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.

 

F

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: