Thank you so much! This is perfect!
So, if i add the year into the column, that would mean if I were to change it to 2013 it would do everything from 2013? - Out of curiosity, how does it know which month is being listed?
Also, I have a bit of a problem, I'm supposed to also add an "exception" rule for hypothetical holidays - how do I do that?
For example: May 28th is an off day.
So if something came in on May 25 - (because May 28th is an off day, it can't count it as part of the working day time.
For 2012 I would have to nix out May 28, July 4, Sept 3, Nov 23-24, Dec 24-25.
I am in awe of how much you can do with excel, and amazed that there is a community of excel experts. Thank you so much for helping me out already.
Bookmarks