WEEKDAY function

Excel » Functions » Date and Time » WEEKDAY function »

How to use the WEEKDAY function

Converts a date to a weekday number from 1 to 7. Formula in cell D3: =WEEKDAY(B3) Excel Function Syntax WEEKDAY(serial_number,[return_type]) […]

Time sheet for work

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

Find date given day and week

La Thăng asks: I want to find day if given date and week, for example : if given Tuesday, 32th […]

Count a specific weekday in a date range

NETWORKDAYS function returns the number of whole workdays between two dates. The array formula in this blog post counts for […]

Monthly calendar template

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

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