Excel formula: Get next day of week

Get next day of week

Get the next day of the week

The WEEKDAY function in Excel automatically returns the next day of the week from a stipulated date as specified in the function.

What Is WEEKDAY Function?

The WEEKDAY function calculates the next day of the week by counting the date forward by 7 days, then steps back to the correct date by subtracting the result based on the specific day signified.

How Is WEEKDAY Function Used In Excel?

The WEEKDAY is entered in Excel along with range and day of the week to be calculated.

Formula or Syntax

=date+7-WEEKDAY(date+7-dow)

Parameters or arguments of WEEKDAY Function

The WEEKDAY function uses the following arguments:

Date: The date Excel is expected to start counting from. It is entered in a cell, so the cell range is entered instead.

Day Of the Week (dow): This signifies the day of the week Excel is expected to count to. Each day of the week is referred with a number assuming Sunday as the first day of the week. Sunday(1), Monday(2), Tuesday(3), Wednesday(4), Thursday(5), Friday(6), Saturday(7).

Example 1

Let us use the WEEKDAY function to calculate the next Wednesday and Friday respectively in the given dates below.

Enter the starting date into Excel worksheet

Figure 1. Showing desired date Excel is expected to start counting from

Use the WEEKDAY function to get the next day of the week

Figure 2. Showing the next Wednesday (4 in the formula represents Wednesday)

Figure 3. Showing the next Friday date (6 in the formula represents Friday)

Note on the usage of WEEKDAY function

Extend cell size for full display of date to avoid results like ‘###########’
The numeral for the day of the week should be correctly entered (e.g 1 for Monday)

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

How do i look up a value using two criteria- week # and day of the week?

An Excelchat Expert solved this problem in 23 mins!

I have employees Start and Finish Times each day during a 7 day week calculating the number of hours worked each day. But when I try to get it to total the hours at the end of the week to compare it to the contracted hours, it doesn't show 37.5 instead its showing 13.5?? What format should be in the total column?

An Excelchat Expert solved this problem in 16 mins!

What formula should I use to get an average of a group of averages. I have data that averages daily data by the day (say data collected on Monday); then data averaged each day of the weel (Tuesday's data, then Wednesdays data, etc. etc. for each day of the week. Now I want to AVERAGE the averages collected for each day of the week to arrive at a WEEKLY average.,. but I can only get a error in the final weekly average cell. This is the formula I jave been ising: =AVERAGEIF(N121:T121,"<>0") What am I doing wrong?

An Excelchat Expert solved this problem in 30 mins!

Post your problem and you'll get expert help in seconds