![]() ![]() If you want to manually format the dates, you can remove the conditional formatting (read about that in the Excel help system). ![]() That means that if you enter "Ted's Birthday" under June 6th, 2013 in cell J13 you can't change the year to 2014, because "Ted's Birthday" will stay in cell J13, but the calendar will show J13 as June 12, 2014.įormatting: The dates are highlighted in the yearly calendar using Conditional Formatting to change the background color. as soon as you start adding stuff to the monthly calendars, the year and start month are locked in. If this limitation is unexceptable, you can try the new Monthly Calendar with Holidays.Īfter you add your own event formulas into the Year worksheet (under the Date and Events columns), then save a backup copy (as a template for example) to be used the next time you create a calendar for the following year. But, note that only the first 2 events per day will be listed in the monthly calendars. ![]() Holidays and Events: If you are comfortable editing and creating formulas, you can use the Holidays/Events table in the Year tab to add some birthdays, anniversaries, or other yearly events. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |