Check if duplicate projects with dates exist

[dubyarly]

Hi, I have a spreadsheet which tracks various projects and tasks within the project. I currently have a formula to provide a count of projects so that multiple tasks with the same project number are not counted twice. However, I need to modify this to check that the dates also match, else it should be given its own project score.

The below works as long as the spreadsheet is sorted by project number, but can throw off the count if sorted by different columns:

=IF(AND([@[NEXEvent.Site Outage: Project ID]]=F1,[@[NEXEvent.Outage Start Date]]=A1,[@[NEXEvent.Outage End Date]]=B1),0,1)

The next attempt accurately counts the duplicate projects, but I'm not sure how to add the start and end date checks to the same line the duplicate projects are found on:

=IF(COUNTIF(Table1[[#Headers],[NEXEvent.Site Outage: Project ID]]:[@[NEXEvent.Site Outage: Project ID]], [@[NEXEvent.Site Outage: Project ID]])>1,0,1)

I'd rather keep this to column formulas, can it be done without VBA?

 

[awoohaw]

Can you post some dummy data to use as some working material? Please use the xl2bb add in (Link below) or post as a table, please.
Also, give a scenario with an expected result.

Thanks in advance.

 

[dubyarly]

Parameters for this assignment have been changed, we won't actually be worried about the dates and I can do this with a simple countif formula. Not sure if this thread should be marked as solved, but it's no longer needed. Thanks for your response @awoohaw