The short answer is yes - I did one a few years ago which allows you
to enter a year between 1900 and 2099 and you get a complete calendar
for that year. You can use conditional formatting to highlight a cell
if it contains a date which is equal to the system date (TODAY() ).

Hope this helps.

Pete

On Aug 14, 11:40 pm, Keyrookie
wrote:
Hi all,

Is there a way to create a calendar in Excel that will always insert
the correct date for months and years? It would also be cool to have
the current date highlighted in some way on the calendar.

Thanks

--
Keyrookie