Schedule


Excel » Schedule »

Get date ranges from a schedule

The above picture shows you two formulas that extract names (column B) and date ranges (column C and D) based […]

Shift Schedule

Geoff asks: Hi Oscar, I have a cross reference table we use for shift scheduling. The x-axis is comprised of […]

Free School Schedule Template

This template makes it easy for you to create a weekly school schedule. The template has hours divided into 10 […]

Weekly appointment calendar

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

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 […]

Schedule recurring events in a weekly schedule

In our sequel about weekly schedule it is now time to create a recurring events. This is what we have […]

Setting up your work hours in a weekly schedule

Hours outside workhours are filled with grey using conditional formattting, except weekends. Conditional formatting formula applied on cell range C6:I29: […]

Populate cells dynamically in a weekly schedule

In this post I am going to add one more function to a weekly schedule, an array formula allows you […]

Find empty hours in a weekly schedule

In this post, I have created som random time ranges. We are going to use these time ranges to extract […]

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 […]

Weekly schedule template

I would like to share this┬ásimple weekly schedule I created. How to use weekly schedule Type any date in cell […]

Calendar with scheduling [vba]

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