Does column A have every date or only the working days? If it has every date then try this formula for H2 copied down
=IF((MONTH(A2)<>MONTH(WORKDAY(A2,2,M$2:M$100)))*NETWORKDAYS(A2,A2),1,"")
or if you only list working days try
=IF(MONTH(A2)<>MONTH(WORKDAY(A2,2,M$2:M$100)),1,"")
assumes that M2:M100 has the holiday dates
Audere est facere
Works like a charm. Thank you so much.
May I be so bold as to ask for some explanation/breakdown of the formula? I would like to complete my project, but I'd also like to learn so as not to take up more time with similar questions in the future. Teach me to fish, please!
So, if I wanted to work wioth a specific month, for example, December, to calculate the last 5 working days, can I use the same formula and substitute December in the place of the 2nd "MONTH" in the formula?
Which formula did you use?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
joeljoel 
Register To Reply
Bookmarks