ExcelBanter - Date Calculation to exclude weekends

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date Calculation to exclude weekends (https://www.excelbanter.com/excel-worksheet-functions/67097-date-calculation-exclude-weekends.html)

Vim

Date Calculation to exclude weekends

Pls Help!

I'm trying to subtract a delivery date with order received date and it shows
a value...fine....but how do get the formula to ignore weekends to show a
true working working and more accurate number of delivery days.

daddylonglegs

Date Calculation to exclude weekends

If you have Analysis ToolPak installed you can use NETWORKDAYS, e.g.

=NETWORKDAYS(A1,B1) where your first date is in A1 and second date in
B1

--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=504437

[email protected]

Date Calculation to exclude weekends

Hello,

I suggest to have a look at:
http://www.sulprobil.com/html/date_formulas.html

HTH,
Bernd

All times are GMT +1. The time now is 11:07 PM.