Count if Greater than 60 Days

[RLJ]

I need to have my formula below modified.

=COUNTIF(Portal_Loans[Date Assigned],"<"&TODAY()-60)

This will give me to total amount of dates in the Portal_Loans[Date Assigned] column, but I ONLY want to count the dates in this column if in Portal_Loans[Date Finalized] is blank.

Basically, I want to know how many outstanding we have due that are older than 60 days, not the total count, only those that have not been finalized per the Date Finalized column in the table.

Thanks for your help!

 

[Marcílio_Lobão]

RLJ, Good afternoon.

Try to use:

=COUNTIFS(Portal_Loans[Date Assigned],"<"&TODAY()-60, Portal_Loans[Date Finalized], "")

Please, tell us if it helped you.

 

[RLJ]

Thanks! it works perfect.

 

[Marcílio_Lobão]

RLJ,

Glad to have helped you.

Thanks for the feedback.