I have a table that I am trying to have a column that counts the number of instances someone is out of the office. However, if the dates are sequential excluding weekends and federal holidays, to count as one instance.
I have a table that I am trying to have a column that counts the number of instances someone is out of the office. However, if the dates are sequential excluding weekends and federal holidays, to count as one instance.
Use a column of formulas to identify blocks of dates, as in the attached. You need to list your holidays in the holidays area highlighted on the sheet.
Bernie Deitrick
Excel MVP 2000-2010
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks