Thanks Sam,
I downloaded a calendar file from
www.dotxls.com that I'm happy with except I can't get a conditional formula to affect the date (TODAY()). It might be the existing formulas in the file...?? I also downloaded the calendar from WinCalendar.com.... nice. But I'm wanting to utilize the Excel calendar so I can chart data ... ya know how it is, we like things a certain way! If I can just conquer the TODAY issue I'd have the file I'm wanting. Perhaps you could download the calendar from dotxls.com and help me resolve the issue?
Thanks for your time,
Tim
Quote:
Originally Posted by TechGuy
Check out WinCalendar - it integrates with Excel as both a date picker
& calendar creator - for any date.
Free Download at WinCalendar.com
Regards
Sam
On Aug 18, 10:03 am, Keyrookie
wrote:
Pete_UK;540445 Wrote:
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 completecalendar
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 acalendarinExcelthat 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 thecalendar.
Thanks
--
Keyrookie-
Thanks Pete,
Is it possible to get a copy of yourcalendar? It would save me a lot
of time!
Thank you,
Keyrookie
--
Keyrookie- Hide quoted text -
- Show quoted text -
|