Whilst searching the online templates from Microsoft, I came across a great “any year calendar” – a calendar that can be re-used year-on-year.
However, when I started using it, I came across a problem due to the way my computer is configured. My computer is set up as UK (well it would be) which means that Excel expects dates to be in day-month-year format, whereas the template is set up to use month-day-year format.
In this video I explain how to amend the formulas in the spreadsheet to make it useable in the UK. Funnily enough a customer sent me a very similar spreadsheet 2 days later with exactly the same problem!
Hi Mike,
Nice solution, but I think I have a more elegant one
In my solution, one can select his date format (set by his System’s settings) and the calendar will display correctly.
I set a data validation field, where the user can select either 0 or 1.
If he chooses: 0 – it means that his system date format is: dd/mm/yy (“Eurpoean”)
If he chooses: 1 – it means that his system date format is: mm/dd/yy (“American”)
In both cases, if his choice is compatible with his system’s date format, then he’ll be able to view the calendar without any problem.
Here’s the link for the file (on Google Drive):
https://docs.google.com/file/d/0B3l5X7tRfy6MVURHZVpIeDBqTkE/edit?usp=sharing
What I’ve done are several things:
1) Add a data validation field (as described above)
2) Made some modifications (and additions) to the Name Manager. You can see them here:
https://docs.google.com/file/d/0B3l5X7tRfy6MUVBGVU5kNGtNTDA/edit?usp=sharing
Attached are 2 additional pictures:
1. The user is an “American” and chose: 1 to view the calendar
2. The user is a “European” and chose: 0 to view the calendar.
https://docs.google.com/file/d/0B3l5X7tRfy6MNkRhaTh3WTZiZG8/edit?usp=sharing
https://docs.google.com/file/d/0B3l5X7tRfy6MMGtBRl9RY2hfbTA/edit?usp=sharing
I’d appreciate it very much if you could tell me your opinion
Best Regards,
Meni Porat
Great solution Meni. Yours takes more work to set up but now it is easier for end users to use no matter what their system is set to. Thanks for taking the time to share it
-Mike-