I am running a countifs formula to pull the "completed on time" work orders for the month, which are those completed within 30 days of issuance. The correct value should be 69 but the formula is returning 46. To verify, I filtered the data down to October completed and ran the difference (Date completed - Date Issued) in an adjacent column and it totals 69 but this formula returns 46. Am I missing something or is there a way to correct the issue:
=COUNTIFS(Dates,">="&DATE($H$1,10,1),Dates,"<="&DATE($H$1,10,31),Type,$A85,Status,$C$2,Completion,"<="&Dates+30)
Where: Dates - Issue Date; H1 - Current Year; Type and Status - Type of work and status of work order; Completion - Completion date
I've verified that everything up to criteria 5 functions properly and I'm using Excel 2016.
Thank you for any assistance you can provide as this is driving me crazy!!!
=COUNTIFS(Dates,">="&DATE($H$1,10,1),Dates,"<="&DATE($H$1,10,31),Type,$A85,Status,$C$2,Completion,"<="&Dates+30)
Where: Dates - Issue Date; H1 - Current Year; Type and Status - Type of work and status of work order; Completion - Completion date
I've verified that everything up to criteria 5 functions properly and I'm using Excel 2016.
Thank you for any assistance you can provide as this is driving me crazy!!!