PDA

View Full Version : Overlap Dates



Abhijeet618
05-01-2015, 04:15 AM
Hi

I have data In Column A has Assignment Column B Has Start Date Column C has End Date

I want find out Data type 2 which assignments fall is data type 1 which dates data for this i use =SUMPRODUCT((G3<=$C$3:$C$10)*(H3>=$B$3:$B$10)*(F3=$A$3:$A$10)) this Formula but Some assignments No End only Start Date is mention in this case i want highlight those dates where those Overlap I mention in Column I
Please tell me