Date series excluding holidays
Posted by Mike H on May 04, 2001 7:39 AM
I am trying to create a series of dates in a column. These are based on a given start date in the first cell and a number of months between the dates between each date, as set in another cell.
The dates should, however, exclude Saturdays and Sundays and a set list of holidays as set in a separate range of cells. Where one of these dates would result the cell should contain the next working day.
Is there a reasonably straightforward way of doing this please without using VBA?