SadiaAslam
New Member
- Joined
- May 17, 2021
- Messages
- 3
- Office Version
- 2013
Hi,
I have seen an old thread which was helpful. I want to be able to identify gaps between two dates by using the formula that was provided in the old thread: =IF(C7=MAX(C$2:C$74),"",IF(SUMPRODUCT((C7+30>=B$2:B$74)*(C7< C$2:C$74))=0,"Gap: " & TEXT(C7,"DD/MM/YYYY") & " to " & TEXT(MIN(IF(B$2:B$74>C7,B$2:B$74)),"DD/MM/YYYY"),""))
However, when I tried the above, it is coming back with 1900 as an end date for the gap and also, calculating a whole bunch of other dates and I am not sure where they are coming from?
Please help!
I have seen an old thread which was helpful. I want to be able to identify gaps between two dates by using the formula that was provided in the old thread: =IF(C7=MAX(C$2:C$74),"",IF(SUMPRODUCT((C7+30>=B$2:B$74)*(C7< C$2:C$74))=0,"Gap: " & TEXT(C7,"DD/MM/YYYY") & " to " & TEXT(MIN(IF(B$2:B$74>C7,B$2:B$74)),"DD/MM/YYYY"),""))
However, when I tried the above, it is coming back with 1900 as an end date for the gap and also, calculating a whole bunch of other dates and I am not sure where they are coming from?
Please help!