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

Comments(5) Filed in categories: Conditional formatting, Cross reference table, Excel, Schedule, Templates

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

Comments(5) Filed in categories: Excel, Schedule, Templates

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

Comments(1) Filed in categories: Calendar, Excel, Schedule

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

Comments(0) Filed in categories: Calendar, Excel, Schedule

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

Comments(0) Filed in categories: Calendar, Excel, Schedule

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

Comments(1) Filed in categories: Calendar, Excel, Schedule

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

Comments(12) Filed in categories: Excel, Schedule

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

Comments(0) Filed in categories: Excel, Schedule

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

Comments(33) Filed in categories: Excel, Schedule

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

Comments(1) Filed in categories: Excel, Schedule

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

Comments(20) Filed in categories: Calendar, Excel, Schedule

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

Comments(8) Filed in categories: Excel, Schedule, Templates

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

Comments(2) Filed in categories: Calendar, Excel, Schedule