Calendar


Excel » Calendar »

Calendar – monthly view

Tesh asks: How easy is it to modify this for recurring tasks (weekdays, weekly, monthly, quarterly and yearly) and maybe […]

Pivot table calendar

Today let's learn how to create a simple pivot table calendar! The animated gif below shows you the pivot table […]

Yet another excel calendar

The first sheet contains an overview. You have the option to select a year, date and color. Days with many "events" […]

Heat map yearly calendar

David asks: Hi, I would like to use this example with my dataset, however, I'd like to visually show the […]

Highlight events in a calendar

Steven asks: I got 6 events with different dates... Event - DATE START - DATE END 1 2 3 4 […]

Use a calendar to filter a table

My previous post Excel calendar (vba) used vba and formulas to extract events. This post demonstrates how to filter a table using […]

Excel calendar [VBA]

This calendar lets you schedule events on the data sheet. Select a cell (calendar date) and events on that day […]

Count and visualize specific weekdays in a custom date range

The sheet demonstrated below let´s you type a custom date range and specific days. The calendar automatically counts and shows […]

Plot date ranges in a calendar part 2

I have created a new version of Visualize date ranges in  a calendar. This excel file let´s you enter names […]

Create a drop down calendar

This drop down calendar uses a "calculation" sheet and a named range. You can copy drop down lists and paste […]

Weekly appointment calendar

This weekly calendar is easy to customize. You can change calendar settings in sheet "Settings": Start date (preferably a monday) […]

Monthly calendar template #2

I have created another monthly calendar template for you to download. Download excel calendar template Monthly-calendar-template #2.xls (Excel 97-2003 Workbook […]

Monthly calendar template

I have created a monthly calendar template for you to download. Download excel calendar template Week starts with sunday Monthly […]

Extract dates from a cell block schedule in excel, part 3

In this post we are going to extract all "not empty" dates in a simple calendar. In a previous blog […]

Extract dates from a cell block schedule in excel, part 2

The obvious question from yesterdays blog post is: How to customize formula to extract dates for all months in calendar? […]

Extract dates from a cell block schedule in excel

Sam asks: One more question for the Calendar that you have set up above can we have a excel formula […]

Highlight specific time ranges in a weekly schedule

In a previous post I created a simple weekly schedule with dynamic dates. In this post I am going to […]

Plot date ranges in a calendar

The image above demonstrates cells highlighted using a conditional formatting formula based on a table containing date ranges. The calendar […]

Calendar with scheduling [vba]

Here is my contribution to all excel calendars out there. My calendar is created in Excel 2007 and uses both […]