Try...
=IF(AND(B7>=D7,B7<=E7),"Worked",IF(AND(B7>=F7,B7<=G7),"Off",""))
in C7 filled down to C371
Currently all rows return "" because all column B dates are earlier than corresponding column D dates.
Beau Nydal
Try...
=IF(AND(B7>=D7,B7<=E7),"Worked",IF(AND(B7>=F7,B7<=G7),"Off",""))
in C7 filled down to C371
Currently all rows return "" because all column B dates are earlier than corresponding column D dates.
Beau Nydal
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks