fill in a series of date without holidays and weekends

M

Monty

I use the formula below to create a column of dates
starting with the date entered in "Y16", based on a
repeating block of time slots in column "Z", E.G
9,10,11,12,13,14,15,16,9,10,ETC.
This works perfect for all days excluding Saturday and
Sunday, but I also would like to exclude a list of
holidays. I know this could be done with about 14 IF
STATEMENTS 1 for each date, but I wondered if anyone had
a better idea.

=IF(Z17>Z16,Y16,IF(WEEKDAY(Y16)=6,Y16+3,IF(WEEKDAY(Y16)
=7,Y16+2,Y16+1)))

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Date Calculation Formula- Calendar days minus Holidays 1
Calculate End Date (excluding weekends and holidays) 6
Date/Time Difference Excluding Weekends & Holidays 2
Search closest day in the past from today 2
Future date with six day week including holidays 1
Date Calculation problem 3
Generate Payment Due Date to exclude Weekends and Public Holiday 4

Top