Calculate how many business days between two dates

[DarkoDeign2]

Hi,

Lets that I have a random date in column A and another random date in Column H.
(2023-04-12) - (2023-07-01) = 80days, this is correct, but I would like to know how many business days (Mon-Fri) there are between these dates.
Is there any smart way to calculate this?

 

[MARK858]

Have a look at the Networkdays and Networkdays.Intl functions

NETWORKDAYS Function

The Excel NETWORKDAYS function calculates the number of working days between two dates. NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays supplied as dates.

exceljet.net

NETWORKDAYS.INTL Function

The Excel NETWORKDAYS.INTL function calculates the number of working days between two dates. NETWORKDAYS.INTL can optionally exclude a list of holidays and provides a way to specify which days of the week are considered weekends.

exceljet.net

 

[awoohaw]

use the networkdays or networkdays.intl function

Book2
	A	B	C	D
1	2023-04-12	2023-07-01		Holidays
2				2023-05-29
3	57	=NETWORKDAYS(A1,B1,D2)
4	57	=NETWORKDAYS.INTL(A1,B1,"0000011",D2)
Sheet1

Cell Formulas
Range	Formula
A1	A1	=DATE(2023,4,12)
B1	B1	=DATE(2023,7,1)
D2	D2	=DATE(2023,5,29)
A3	A3	=NETWORKDAYS(A1,B1,D2)
B3:B4	B3	=FORMULATEXT(A3)
A4	A4	=NETWORKDAYS.INTL(A1,B1,"0000011",D2)

 

[DarkoDeign2]

Thank you for the help.

 

[awoohaw]

Thank you for the help.

my pleasure!

Best Wishes!