If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

calculate

Thread starter libra101010
Start date Dec 27, 2022

L

libra101010

New Member

Dec 27, 2022

#1

hello

how to calculate the number of workdays between two dates?

Excel Facts

What is the fastest way to copy a formula?

Click here to reveal answer

If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Sort by date Sort by votes

Fluff

MrExcel MVP, Moderator

Dec 27, 2022

#2

Use the NETWORKDAYS function.

Upvote 0

You must log in or register to reply here.

Similar threads

R

Solved

Subtracting all calendar days, but end date cannot fall on a weekend or holiday. If it does, the end date shifts to the preceding work day.

Replies: 8

Views: 225

Monday at 2:00 PM

Romy

R

E

Solved

How to Use IF Statement with WORKDAY function

Replies: 5

Views: 267

Mar 8, 2024

Fluff

E

Solved

How to use WORKDAY to calculate the Final Training Day and exclude Weekends and Public Holidays

Replies: 5

Views: 245

Mar 6, 2024

Fluff

E

Solved

Need help to determine a date

Replies: 3

Views: 75

Apr 2, 2024

awoohaw

E

Solved

Unexpected flaw in WORKDAY formula to calculate date

Replies: 7

Views: 338

Feb 28, 2024

KRice

K

Share:

Facebook X (Twitter) Reddit Pinterest Tumblr WhatsApp Email Link

Forum statistics

Threads: 1,214,832

Messages: 6,121,853

Members: 449,051

Latest member: excelquestion515

Share this page

Facebook X (Twitter) Reddit Pinterest Tumblr WhatsApp Email Link

Top