Can anyone suggest a formula that would work for the below:
I'm looking for 3 outputs for the 'Company Paid?' column - Pending, Overdue & Paid.
Pending - when 'date paid' is blank and todays date is <'Due date'
Overdue - when 'date paid' is blank and todays date is >'Due date'
Paid - when 'date paid' is not blank
I've got as far as:
=IF((AND(ISBLANK([@[Date Paid]]), [@[Due Date]]<TODAY())), "OVERDUE", "Pending")
but i'm stuck on how to then add in the 'Paid' element for when a date has been input into the 'Date Paid' column.
Any help would be appreciated!
Due Date | Date Paid | Company Paid? |
|
I'm looking for 3 outputs for the 'Company Paid?' column - Pending, Overdue & Paid.
Pending - when 'date paid' is blank and todays date is <'Due date'
Overdue - when 'date paid' is blank and todays date is >'Due date'
Paid - when 'date paid' is not blank
I've got as far as:
=IF((AND(ISBLANK([@[Date Paid]]), [@[Due Date]]<TODAY())), "OVERDUE", "Pending")
but i'm stuck on how to then add in the 'Paid' element for when a date has been input into the 'Date Paid' column.
Any help would be appreciated!