rebelandduke
New Member
- Joined
- Feb 10, 2022
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
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?
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?
