• 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.

Overlap The Dates

A

Abhijeet

Active Member
Hi

I Have Data From that i want pull Which Dates are Overlap that Data i want to Pull i have mention in attach file. I use =SUMPRODUCT((G3<=$C$3:$C$100)*(H3>=$B$3:$B$100)*(F3=$A$3:$A$100)) this formula to Identify the Overlap the dates but i want to Pull the Data That is Assignment then Start Date & End Date.I Show in Same Sheet these Info but Expected result give me in Next sheet then also Ok.
2nd thing
In Data type 1 If any Assignment Only Start Date is Mention No End Date then Those Assignment & Start Date data i want in Next Sheet

3rd thing
In Data Type 2
If Start Date > End Date Then Show Message Or Hight light that Data (Wrong Data in this Data Set)

4th Thing

In Data Type2
If Any dates are Overlap in Same Data Then Show those Data in Next sheet

Please tell me how to do this
 

Attachments

  • Date for absence falls between.xlsx
    13.2 KB · Views: 2
1st Input Data Range is For Data Type 1 is A3:C100000 depend upon data but max range is this. Data Type 2 Range is F3:H10000 it is also depend upon Data but Max Range is this

2nd Output to be place in Sheet2 Range is Column A2:C This Output Data for Overlap Data i want in this worksheet
Where is End Date Not mention only Start Date is mention This type of Data Pull from Data Type1 i.e A3:C100000 Pull in Sheet3 Range is Column A2:C
From Data Type 2 i.e F3:H10000 Same Data look any Overlap the Dates That Output Goes in Sheet4 Range is Column A2:c
Last Criteria is In Data Type 2 i.e is Range F3:H10000 where Start Date > End Date If this Criteria match then Show in Column J the Result Wrong Data in this Data Set
Please tell me how to do this
 
You must log in or register to reply here.
Back
Top