I have seen many posts on calculating the number of days between two dates and subtracting the number of holidays. Ex. =NETWORKDAYS(StartDate,EndDate) does that very nicely.
My question is, how do I determine what workday number today is so I can figure out how many workdays are left in the month.
I did come up with a formula that tells me how many calenadar days are left in the month:
=(EOMONTH(TODAY(),0)-TODAY()) but it doesn't tell me how many workdays are left and I have been unable to adapt it.
For example, today is Aug 29th. The first formula tells me there are 22 working days in Aug. while the 2nd formula tells me there are 2 days left in the month, but there is only one working day left in the month. I would like to accomplish this using only one cell as input, which is a hardcoded "Period ending date" which is typically yesterday. Thank you.