slamanager
Board Regular
- Joined
- Apr 20, 2007
- Messages
- 129
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
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