Dealing with Public holidays

[slamanager]

Hi All,

Something ive been dealing with today is a simple calender based on a supplied date but ive not been able to get any nominated holidays to be excluded from the display.

A11 I have a weekday date dd/mm/yyyy
A10 =IF(WEEKDAY(A11)=7,A11-1,IF(WEEKDAY(A11)=2,A11-3,IF(WEEKDAY(A11)=1,6,A11-1)))
this formula is copied in cells A10 to a1 in a14:a99 i want to type in any holidays for the next few years and get them not to display in any cal days of A1:A10

Ive tried Networkdays but then i get stuck working to exclude Saturday and Sundays.
Unless i show all these too as holidays ?

is there an obvious way to complete this situation

Many thanks

 

[Ganjin]

hmm, try this in A10:
=WORKDAY(A11,-1,$A$14:$A99)

 

[slamanager]

Many thanks didnt see the workday function many thnaks for the reply tested and all ok