Hi all,
I need help as I am totally blank in how to solve this.
I have sheet with a row of random dates. I need to count the dates within a specific week (form Monday to Friday) the specific week number is in textbox1 the specific year is in textbox2.
I tried to work with Application.WorksheetFunction.CountIfs, and weeknum but at the moment I am totally stuck in how to solve this.
looking forwards to any help!
Bookmarks