Count of calendar days to business days

[Sparty22]

I would appreciate any suggestions on the following as I am truly stuck.

I have a system that reports the number of calendar days a request has been in queue , but my teams SLA is based on business days. I need to be able to convert this number from calendar days to business days.

For example, on my report today it lists requests with the number of calendar days as 1.76, 3.59, 14.11 and 7.14. I need a formula/function to determine how many business days these requests have been in queue. I would also need to take into account a list of company holidays.

I appreciate any help that can be provided on this. Thank you!

 

[Fluff]

Hi & welcome to MrExcel.
Do you know the start date?

 

[Sparty22]

My dates are the ‘in department age’ and not based off the actual start date. It doesn’t provide the date it was routed to my team. The report is run each morning so the number of days is calculated off of today’s date.

 

[Fluff]

If you don't know the start I don't see anyway of doing it.
For instance if you had 4 days it could be 2,3 or 4 days (ignoring holidays) depending on whether the start date was a Mon, Tues, Wed etc.

 

[Sparty22]

We calculate the start date by =Today()-A1. The start date of all the request will vary.

 

[Fluff]

Is this what you mean

+Fluff v2.xlsm
	A	B	C	D	E	F
1	Days	Work days				Holidays
2	1	2				30/09/2020
3	2	3				05/10/2020
4	3	3				12/10/2020
5	4	3
6	5	3
7	6	4
8	7	5
9	8	6
10	9	7
11	10	7
12	11	7
13	12	7
14	13	8
15	14	9
16	15	9
17	16	10
18
Master

Cell Formulas
Range	Formula
B2:B17	B2	=NETWORKDAYS.INTL(TODAY()-A2,TODAY(),1,$F$2:$F$4)

 

[Sparty22]

Yes, I think this will work. Thank you for your help.

 

[Fluff]

You're welcome & thanks for the feedback.