I need a formula that goes in B2 and then down that states:
IF A2 is a Sunday then 0 (Zero)
IF A2 is listed in the named range Holidays then 0 (Zero)
If A2 is a Saturday then 'Set Up Sheet'!R2
If A2 is a Working day then 'Set Up Sheet'!Q2
Beware, there can be occurrences like Saturday 1st January where this date
is both a holiday and a Saturday so should return a 0 (Zero)
Then to use this formula in other sheets for different months.
Thanks in advance,
BVG
Bookmarks