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 […]
Geoff asks: Hi Oscar, I have a cross reference table we use for shift scheduling. The x-axis is comprised of […]
This template makes it easy for you to create a weekly school schedule. The template has hours divided into 10 […]
Weekly appointment calendar in excel
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 in excel
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 […]
Welcome! I am 