Working Dates and Off Dates Formula

Originally Posted by jettechfsr

Here is what finally worked


=ArrayFormula(if(sumproduct(B6>=D$6:D,B6<=E$6:E),"worked",if(sumproduct(B6>=F$6:F,B6<=G$6:G),"OFF","")))

That just produced the NAME error for me.
This array formula however resulted in a blank in C6 and either Worked or Off in the other column cells...

IF(SUM(IF((B7>=$D$7:$D$371)*(B7<=$E$7:$E$371),1,0)),"Worked",IF(SUM(IF((B7>=$F$7:$F$371)*(B7<=$G$7:$G$371),1,0)),"Off",""))

Beau Nydal