 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2004Calendar in Excel
Can someone help me with a calendar to use in Excel that can be formatted so as to show special dates, current holidays, etc. WARNING: I need explicit instructions. This sort of stuff is not intuitive to me. Thanks, Dot Hi Dot can you give us a bit more of an idea of how you want the calendar to work ... do you just want to see a date and change the colour of the date to indicate holidays etc, or would you like the date and room to write notes ... what period of time are you looking at (1 month / 1 year ???), what do you want to use the calendar for? Are you going to update the calendar in Excel, or do you just want to print it out & stick it on the wall ... have you got any other microsoft applications available to you that you could use instead of excel (as there might be a better alternative depending on what you want to do with it). Cheers JulieD > Can someone help me with a calendar to use in Excel that > can be formatted so as to show special dates, current [quoted text clipped - 3 lines] > Thanks, > Dot I want to be able to update the calendar with personal dates, have holidays show, be able to print it. A month at a time is great. I have a calendar for .xls from a Chip Pearson that has 3 worksheets, but I haven't the faintest idea how to fix a bug that comes up when I run it. Thanks, Dot Hi Dot haven't seen Chip's calendar but what's the bug? Cheers JulieD > I want to be able to update the calendar with personal > dates, have holidays show, be able to print it. A month at [quoted text clipped - 5 lines] > Thanks, > Dot What bug comes up? I use it in various applications etc : I want to be able to update the calendar with personal : dates, have holidays show, be able to print it. A month at [quoted text clipped - 5 lines] : Thanks, : Dot .When I open it, first it gives me the warning about MACROS, which I "enable", then the debug windown comes up with Run-time error: 13 Type mismatch Then when I debug, this part is highlighted Range("StatusCell").Value = Format(TempDate, "mmm d, yyyy") _ & " " & Format(DayOfYear(TempDate), "##0") & _ NumberSuffix(DayOfYear(TempDate)) & " day of year." & _ " Days From Now: " & Format(DateDiff("d", Now(), TempDate), "##,##0") & _ " (Workdays: " & _ Format(Evaluate("NETWORKDAYS(" & """" & Format(Now(), "mm/dd/yy") & _ """" & Application.International(xlListSeparator) & _ """" & Format(TempDate, "mm/dd/yy") & """" & ")")) & ")" What version of Excel are you using? The Calendar file works fine for me.  SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com > .When I open it, first it gives me the warning about > MACROS, which I "enable", then the debug windown comes up [quoted text clipped - 18 lines] > """" & Format(TempDate, "mm/dd/yy") & """" & > ")")) & ")" You MUST have the Analysis Tool Pak addin loaded to use the Calendar file. Go to the Tools menu, choose Add Ins, and put a check next to the Analysis Tool Pak. SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com > .When I open it, first it gives me the warning about > MACROS, which I "enable", then the debug windown comes up [quoted text clipped - 18 lines] > """" & Format(TempDate, "mm/dd/yy") & """" & > ")")) & ")" YES!!! It worked. THanks a bunch. Cheers, Dot |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.