How many days are in a month without including weekends?

Returns the number of net working days between two provided days.

Table of Contents Show

Sample Usage
Count Days from a Date
How to use the day counter
Counting days from a date
Day of the week
The Doomsday rule
How many days are in a month not including weekends?
How many working days are in a month excluding Saturday and Sunday?
How many days are there in 2022 excluding weekends?
How do you calculate days without weekends?

Sample Usage

NETWORKDAYS(DATE(1969,7,16),DATE(1969,7,24))

NETWORKDAYS(A2,B2)

NETWORKDAYS(40909,40924)

NETWORKDAYS(40900,40950,{40909,40924})

Syntax

NETWORKDAYS(start_date, end_date, [holidays])

start_date - The start date of the period from which to calculate the number of net working days.
end_date - The end date of the period from which to calculate the number of net working days.
holidays - [ OPTIONAL ] - A range or array constant containing the date serial numbers to consider holidays.
- The values provided within an array for holidays must be date serial number values, as returned by N or date values, as returned by DATE, DATEVALUE or TO_DATE. Values specified by a range should be standard date values or date serial numbers.

Notes

NETWORKDAYS does not autoconvert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore, NETWORKDAYS(10/10/2000,10/10/2001) is interpreted as NETWORKDAYS(0.005,0.00499750124938), the quotients of 10 divided by 10 divided by 2000 and 2001, respectively.
NETWORKDAYS calculates the number of work days between two dates. To calculate the working day a specific number of days ahead of a date, use WORKDAY.
NETWORKDAYS works similarly to NETWORKDAYS.INTL but only treats Saturday and Sunday as the weekend. Use NETWORKDAYS.INTL to use other days of the week as the weekend.

Examples

Returns the number of workdays between the start_date and end_date (based on the given list of holidays).

Was this helpful?

How can we improve it?

Use this counter to find the number of days between two dates, including the number of working days, weekends, and holidays. Click "Settings" to define holidays.

Count Days from a Date

The day counter or days calculator above can be used in situations such as counting down to a birthday, counting the number of days into a pregnancy, the number of business days left for a project, etc.

How to use the day counter

To use the day counter, use the drop-down menus to select a starting month, date, and year. Check the "include end day" box if the end day should be included in the count. For example, if a project is due at 11:59 PM on April 24th, and the current day is March 29th, select those dates, and use the check box to include the end day. Alternatively, selecting April 25th as the end day and not checking the "include end day" box would provide the same result.

The calculator has additional settings, accessible by clicking the "Settings" link. Select whether or not to include holidays. If you would like to include holidays, select which common US holidays to include, and/or use the table below to enter other holidays. The calculator result will include a count of the number of holidays included in the chosen time span.

The calculator returns the number of days between the selected date assuming a Monday to Friday work week and that the weekend falls on Saturday and Sunday. It breaks down the total number of days into weekend days and weekdays by default, but can also include common or specified holidays (both in the count as well as listing the holidays). The calculator always counts the start date as a full day, and counts the last date as a full day if the "include end day" box is selected. If the box is not selected, the end date is not included in the calculation.

Counting days from a date

Given a start date and a selected number of days to add or subtract, the calculator will determine the resulting date. The "count business days only" checkbox determines whether or not the selected number of days includes weekends. For example, if the box is checked, the day selected is a Monday, and if 7 days were added to that, the calculator result will be Wednesday the following week, not Monday, since Saturday and Sunday would not be counted.

Day of the week

The calculator also shows the day of the week for the chosen dates. There are many different algorithms for calculating the day of the week. One of these is referred to as the Doomsday rule, an algorithm developed by John Conway that, with practice, can be done mentally.

Doomsdays

The algorithm is based on "doomsdays," which are specific dates that all fall on a certain day of the week in a given year. These dates are the same for every year, but the day they all fall on changes with each year. The table below shows the doomsdays for each month of the year.

Doomsdays by month

Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
1/3*	2/28*	3/14	4/4	5/9	6/6	7/11	8/8	9/5	10/10	11/7	12/12

*On a leap year, the doomsday for January is 1/4 instead of 1/3 and the doomsday for February is 2/29 instead of 2/28.

It is necessary to memorize these dates to be able to determine the day of the week, given any date. For the even months, except for February, all of the doomsdays occur on the day corresponding to the given month (4/4, 6/6, 8/8, 10/10, 12/12). February's doomsday occurs on the last day of the month, or the 28th in a typical year or the 29th in a leap year. January's occurs on the 3rd, or 4th during a leap year (1/3 or 1/4). March's doomsday can be remembered as the first 3 digits of π, 3.14 (3/14). The remaining odd months can be remembered using the mnemonic "I work from 9 to 5 at 7-11." July can be remembered along with November, where July's doomsday falls on 7/11 and November's is the same except that the day and month are switched (11/7). Similarly, September can be remembered as "working 9 to 5," or 9/5, where May's doomsday is the same, again with the position of the day and month switched (5/9).

Anchor day

The anchor day is the doomsday for a given century. The doomsday for a given year is calculated relative to the anchor day for the century. For example, the doomsday for the year 2000 was Tuesday. For 1900 it was Wednesday, and for 2100 it will be a Sunday. The Gregorian calendar (the most widely used calendar) cycles every 400 years. Thus, it is only necessary to memorize the anchor day for four centuries. Any other anchor day for any century can be determined relative to the anchor days for any chosen consecutive span of four centuries. For example, using the centuries 1900, 2000, 2100, and 2200, their anchor days are as follows:

Anchor days by century

1900	2000	2100	2200
Wednesday	Tuesday	Sunday	Friday

Thus, the anchor day in the year 1500 (1900 - 400) is also a Wednesday. In the year 3000 (2200 + 400 + 400), the anchor day will be a Friday, and so on.

To perform the algorithm, it is also necessary to assign numbers to each day of the week:

Numerical representation of days of the week

Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
0	1	2	3	4	5	6

Given that the above is memorized (or can be referenced), determining the day of the week given any date just requires the use of basic arithmetic and the following set of rules.

The Doomsday rule

The algorithm is as follows:

Determine the anchor day for the given century; assign this to the variable a.
Divide the last two digits in the year by 12; assign the result, ignoring any remainder, to b. If the last two digits in the year is less than 12, b = 0.
Assign any remainder to c. If there is no remainder, c is 0.
Divide c by 4, ignoring any remainder. If c is less than 4, c = 0.
Find the sum of a + b + c + d; assign the result to e.
Subtract 7 from e until e is 6 or less (this simplifies the arithmetic since any day +/- some multiple of 7 will be the same day); assign the result to f. f represents the day on which doomsday falls in the given year.
Determine the closest doomsday to the selected date (pay attention to whether the year is a leap year if the chosen date is in January or February). For example, if the selected date is 4/17, the closest doomsday is 4/4.
Count forward or back from the closest doomsday to the selected date, keeping in mind that every +/- 7 days will be the same day, so 4/11, 4/18, 4/25 occur on the same day as 4/4. Each of these dates can be thought of as doomsdays, so if the selected date is 4/15, that is 4 days after a doomsday equivalent, 4/11, or 3 days before another doomsday equivalent, 4/18. If doomsday that year is Thursday, adding 3 days, or subtracting four days, would give the same result: Sunday.

Example:

What day was 3/15/2292?

The anchor day for 2200 is Friday, so a = 5.
92/12 = 7 (remainder 8), so b = 7.
The remainder is 8, so c = 8.
8 / 4 = 2, so d = 2.
e = 5 + 7 + 8 + 2 = 22.
22 - 7(3) = 1, so f = 1, or Monday.
The closest doomsday to 3/15 is 3/14.
3/15 is one day after a doomsday (Monday), so 1 + 1 = 2, or Tuesday.

Thus, 3/15/2292 was a Tuesday.

How many days are in a month not including weekends?

How many business days do we have in a month? It typically ranges between 19-22 days, considering a 5-day workweek. Since the number of days varies from month to month, the number of workdays also varies. If we consider a 6-day workweek, the number of workdays varies between 24-27 days.

How many working days are in a month excluding Saturday and Sunday?

In this case only that 4 sunday have to remove from 30 days means working days comes to 30 - 4 = 26. (26 days).

How many days are there in 2022 excluding weekends?

Payroll Services There are a total of 260 working days in the 2022 calendar year.

How do you calculate days without weekends?

To add days excluding weekends, you can do as below: Select a blank cell and type this formula =WORKDAY(A2,B2), and press Enter key to get result. Tip: In the formula, A2 is the start date, B2 is the days you want to add. Now the end date which add 45 business days excluding weekends has been shown.