Number of days shipped in a month

[rebelandduke]

Hey guys! Need help is there a formula to calculate how many shipping days a date is (minus weekends/holidays?)
For example, yesterday was 2-9, it was the 7th day shipped out of the 20 shipping days in February.
I can get how many total shipping days there are in a month minus weekends and holidays: =NETWORKDAYS(A15,EOMONTH(A15,0),HolidayList)
But how do I get excel to calculate what the shipped day was? How do I get it to tell me that 2-9 was the 7th shipping day in the month?

So I'm trying to get the data in the yellow column without having to manually figure it out and type it in.
I used this formula the the Days shipped column: =NETWORKDAYS(A33,EOMONTH(A33,0),HolidayList) but it's numbering them backwards in descending order. I need it to count what day it is.
I used this formula in the Days of the month column= =DAY(A33) but it's literally just counting, and it won't let me exclude weekends/holidays.
Is there a formula or VBA code I could use?

 

[BSALV]

you can add the holidays as 4th parameter in the formulas of column C

Map1
	A	B	C
1	date	day	shipped
2	di 02/01/22	1	1
3	wo 02/02/22	2	2
4	do 02/03/22	3	3
5	vr 02/04/22	4	4
6	za 02/05/22	5	4
7	zo 02/06/22	6	4
8	ma 02/07/22	7	5
9	di 02/08/22	8	6
10	wo 02/09/22	9	7
11	do 02/10/22	10	8
12	vr 02/11/22	11	9
13	za 02/12/22	12	9
14	zo 02/13/22	13	9
15	ma 02/14/22	14	10
16	di 02/15/22	15	11
17	wo 02/16/22	16	12
Blad3

Cell Formulas
Range	Formula
B2:B17	B2	=DAY(A2)
C2:C17	C2	=NETWORKDAYS.INTL(A2-DAY(A2)+1,A2,1)
A3:A17	A3	=+A2+1

 

[JamesCanale]

MrExcelPlayground6.xlsx
	R	S
5	2/1/2022	1
6	2/2/2022	2
7	2/3/2022	3
8	2/4/2022	4
9	2/5/2022	4
10	2/6/2022	4
11	2/7/2022	5
12	2/8/2022	6
13	2/9/2022	7
14	2/10/2022	8
15	2/11/2022	9
16	2/12/2022	9
17	2/13/2022	9
18	2/14/2022	10
19	2/15/2022	11
20	2/16/2022	12
21	2/17/2022	13
22	2/18/2022	14
23	2/19/2022	14
Sheet31

Cell Formulas
Range	Formula
S5:S23	S5	=NETWORKDAYS(EOMONTH(R5,-1)+1,R5)
R6:R23	R6	=R5+1

 

[rebelandduke]

Thank you, that's close but it's not taking into account the Holidays... and it's putting January 1, & 2 at 0 when they should be 1?

 

[rebelandduke]

I fixed the holiday list portion, but can't figure out why Jan 1, 2 are 0

 

[rebelandduke]

I fixed the holiday list portion, but can't figure out why Jan 1, 2 are 0
View attachment 57485

It's also giving May 1st a 0, and October 1&2 a 0?

 

[Fluff]

I fixed the holiday list portion, but can't figure out why Jan 1, 2 are 0

Because they are weekends.

 

[rebelandduke]

Because they are weekends.

But I need them to roll into 1? Is there a way to do that or will I have to manually override them with 1?

 

[Fluff]

How about

=MAX(1,NETWORKDAYS(EOMONTH(A2,-1)+1,A2,HolidayList))

 

[rebelandduke]

How about

=MAX(1,NETWORKDAYS(EOMONTH(A2,-1)+1,A2,HolidayList))

YES!!!!!! That totally fixed it!! THANK YOU SOOOOO MUCH!!!!!!