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 use This Formula =SUMPRODUCT((G3<=$C$3:$C$10)*(H3>=$B$3:$B$10)*(F3=$A$3:$A$10))
But in data some where only Start Date is mention no End Date so i want where the Overlap the date i want that Start Date I mention In Column I