ExcelBanter - Calculating number of workdays

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

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

- - Calculating number of workdays (https://www.excelbanter.com/excel-worksheet-functions/107921-calculating-number-workdays.html)

Calculating number of workdays

Hello,

I need to calculate the number of working days (monday to friday) between
two dates.
For example: the number of working days between 2006-08-25 and 2006-08-28
should be 1, since the 26th and 27th are saturday and sunday. The datediff
function however returns 3.

Is there another function I can use or do I have to write a custom function?

Regards
PO

Dave F

Calculating number of workdays

Use the function NETWORKDAYS
--
Brevity is the soul of wit.

"PO" wrote:

Hello,

I need to calculate the number of working days (monday to friday) between
two dates.
For example: the number of working days between 2006-08-25 and 2006-08-28
should be 1, since the 26th and 27th are saturday and sunday. The datediff
function however returns 3.

Is there another function I can use or do I have to write a custom function?

Regards
PO

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