• Dave Foord
  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,632 other followers

  • Dave Foords Twitter

    • Headline in news that having 1 alcoholic drink a day could shorten life. To reduce the risk I think I’ll increase to 2 drinks per day! 1 week ago
    • A lot of my work at the moment, and I expect for the next few weeks, is helping clients get their #moodle sites ready for #GDPR 1 week ago
    • RT @alistairm: Many students experience needless barriers. #Accessibility & #inclusion are often left to specialists but standard tech in H… 1 week ago
    • RT @EmathsUK: It is bonkers that this petition is not getting more traction. A centralised, free to use service for advertising all teachi… 2 weeks ago
    • After 2 weeks off, back into all things #Moodle for different clients. Lots of upgrading getting ready for GDPR 2 weeks ago
  • Advertisements

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:

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.



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.


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: