• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to find out Start Date & end date between the dates in next data type

Abhijeet

Active Member
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
Please tell me
 

Attachments

  • Dates.xlsx
    9.5 KB · Views: 0
Hi Abhijeet ,

See your file ; I have used Conditional Formatting to colour the cells ; the formula used in the CF is shown in column K.

Narayan
 

Attachments

  • Dates1.xlsx
    10.1 KB · Views: 0
Hi John ,

Should it not be :

=COUNTIFS($A$3:$A$6,$F3,$B$3:$B$6,"<="&$H3,$C$3:$C$6,">="&$G3)

since we only want to check for an overlap , not that the second set of dates is entirely contained within the first.

See the attached file.

Narayan
 

Attachments

  • Dates1.xlsx
    10.3 KB · Views: 1
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
 

Attachments

  • Date for absence falls between.xlsx
    10.5 KB · Views: 0
Back
Top