Hello check this pic http://imgur.com/VEW4khL
I have all dates from 1 jan 2011 to 31/ dec 2015 in column "B"
I have holidays in column "F"

I want a formula to find these holiday dates of column "F" in column "B" and write "2" in adjoining column "C" if there is holiday other wise "1"
I also want "2" in column "C" if there is sunday or saturday in column "C" dates other wise "1"

Result I want see pic http://imgur.com/wRAnusN
check result I want in column "C"
I want nothing in column "D",I have given this in pic just for illustration