# Calculate the number of Workdays/Weekdays between 2 dates

#### WLHagen

##### Board Regular
I'm trying to calculate the number of weekdays between 2 given dates to calculate retro pay for a salaried employee. The increase should have been effective 01/01/2013, but I just found out about the increase today.

B4 = End date for retro pay calculation (end of last payperiod - for me, that's 03/10/2013
B3 - 01/01/2013 (effective date of the increase).

Because the employee is a salaried employee, they get paid for a standard 40 hour work week, regardless of holiday, so I just need to determine the actual number of business days (weekdays) between the 2 dates.

I tried =((weekday(b4) - weekday (b3)) and got -2, which I'm guessing is the difference between Sunday, March 10 and Tuesday, January 1?

I'm using Excel2010. Thanks in advance for any/all assistance!!

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
I found it..... NETWORKDAYS..... sheesh!

Replies
1
Views
399
Replies
23
Views
351
Replies
2
Views
564
Replies
3
Views
207
Replies
4
Views
565

1,196,078
Messages
6,013,304
Members
441,760
Latest member
Sharina

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back