Hey All,
I need your help..
I have a workbook with two separate tabs (SRO & TC). I am basically using 2 of the same column titles in both tabs (Account Number & Complete Date. In the attachment... the accounts numbers are exactly alike and lined up in both tabs. The difference is, the completed date.
What I am looking for, is a formula to tell me based on the acct #s in the "SRO" Excel Forum.xlsxtab, if that same acct # in the "TC" tab has a completed date within 30 days of the completed SRO date.
This is the formula I tried to use: =COUNTIFS(TC!A:A,SRO!A:A,SRO!B:B,">"&TC!$B:B-30)=1 The formula should show "TRUE" is there was an acct that had a TC within 30 days and "FALSE" if it was more than 30 days.
I have attached a file .. I tried placing the formula in column "K"
Each row should show "true" except for row "10".
Bookmarks