Calendar calculations excluding specific dates

[dk14]

Hi,

I'm preparing a project schedule by adding number of days to certain dates, but would like to exclude a list of specific dates (ie Sundays and holidays) in the calculation.

Workday function doesn't help me as it excludes both Saturdays and Sundays.

Any help is appreciated.

Thanks!

[VBA Noob]

Hi,

This might give you half the solution. Say A1 has your start date then enter this in A2 and drag down

=IF(WEEKDAY(A1+1)=1,A1+2,A1+1)

It ignores Sunday's. Paste special value's

Then you could either make a small table of Holiday dates and do a vlookup to flag holdiays and filter on the helper column to delete

VBA Noob

[daddylonglegs]

Not particularly simple to do but you could use this formula

=SMALL(IF((WEEKDAY(ROW(INDIRECT(A2+1&":"&WORKDAY(A2,B2,G$1:G$10))))<>1)*(ISNA(MATCH(ROW(INDIRECT(A2+1&":"&WORKDAY(A2,B2,G$1:G$10))),G$1:G$10,0))),ROW(INDIRECT(A2+1&":"&WORKDAY(A2,B2,G$1:G$10)))),B2)

confirmed with CTRL+SHIFT+ENTER

where A2 is the start date, B2 the number of days to add and G1:G10 contains holiday dates