Re: find anywhere in A and B anything from C
I have amended this formula in D column a lil bit but I dont think it is good :
=(GrpSize-SUMPRODUCT((HOLfrom>=F5)*(HOLtill<=G5)))*CapPerHead
yours was:
=(GrpSize-SUMPRODUCT((HOLfrom<=F5)*(HOLtill>=F5)))*CapPerHead
Which one is correct??
Because with your formula I dont get any results when date for holidays is entered(I guess it was a typo on you side)
But with my amended formula I get results except they are not quite correct
Can you check this out and let me know
thnx
Saban