WEEKDAY function

Excel » Functions » Date and Time » WEEKDAY function »

How to highlight weekends [Conditional Formatting]

The image above shows conditional formatting applied to cell range C8:C20, it highlights cells containing dates that fall on Saturdays […]

Count specific WEEKDAYS between two dates

If you want to count specific weekdays like for example Mondays and Wednesdays you need a more complicated array formula. […]

How to use the WEEKDAY function

The WEEKDAY function converts a date to a weekday number from 1 to 7. You can customize the function so […]

Time sheet for work

I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for […]

Calendar – monthly view

This article describes how to build a calendar showing all days in a chosen month with corresponding scheduled events. What's […]

Calculate date given weekday and week number

This article demonstrates a formula that returns a date based on a week number and a weekday like Sun to […]

Pivot Table calendar

This article demonstrates how to build a calendar in Excel. The calendar is created as a Pivot Table which makes […]

Create date ranges that stay within month

This article demonstrates a formula that creates date ranges based on a given number of days and the end date […]

Count a specific weekday in a date range

NETWORKDAYS function returns the number of whole workdays between two dates, however the array formula I am going to demonstrate […]

Monthly calendar template

The image above shows a calendar that is dynamic meaning you choose year and month and the calendar instantly updates […]

Setting up your work hours in a weekly schedule

The image above demonstrates conditional formatting¬†highlighting hours outside work hours, those cells are filled with grey except weekends. Conditional formatting […]

Populate cells dynamically in a weekly schedule

In this post I am going to add one more function to the weekly schedule I built in a previous […]

Calculate machine utilization

Question: I need to calculate how many hours a machine is utilized in a company with a night and day […]

How to calculate a date based on specific weekday in a month

Question: How to calculate the date of the third Monday of a given month? Answer: Column B contains dates of […]