Determining Past Due on Outside Vendor Orders

**greggatz** · 06-18-2015, 05:54 PM

I'm trying to build a spreadsheet that will identify if a job is past due from our vendors. The issue I run into is when I'm trying to identify that the order is past due and we haven't received it yet.

I've got an example of the spreadsheet I'm working with...

Basically I need a formula that will say...if received date is blank and the due date is less than today, enter yes OR if the received date is greater than the due date enter yes, otherwise leave blank.

I've tried an IF(AND formula...but it's returning a value of FALSE.

Pretty sure it's operator error...

**JieJenn** · 06-18-2015, 05:57 PM

In F2, give this formula a try

=IF(AND(Table1[[#This Row],[Received]]="",Table1[[#This Row],[Due Date]]<TEXT(NOW(),"mm/dd/yy")),"Yes",IF(Table1[[#This Row],[Received]]>Table1[[#This Row],[Due Date]],"Yes",""))

**greggatz** · 06-18-2015, 06:25 PM

works like a charm! Thanks!

now I just need to pick apart the formula to understand the why for future reference

Determining Past Due on Outside Vendor Orders

LinkBack

Thread Tools

Rate This Thread

Display

Determining Past Due on Outside Vendor Orders

Re: Determining Past Due on Outside Vendor Orders

Re: Determining Past Due on Outside Vendor Orders

Thread Information

Users Browsing this Thread

Similar Threads

Help calculating monthly orders depending on cumulative orders to date

Create orders log and monthly report for all orders

[SOLVED] Calculate total dollar amount the is past the past due date

Calculate orders past agreed dates in pivot table and averages in pivot tables

Determining If Occurrences Exist Within Past 30 Days

Bookmarks

Bookmarks

Posting Permissions