Results 1 to 3 of 3

Determining Past Due on Outside Vendor Orders

Threaded View

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Torrance, CA
    MS-Off Ver
    Excel 2013
    Posts
    75

    Determining Past Due on Outside Vendor Orders

    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...
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help calculating monthly orders depending on cumulative orders to date
    By nats2412 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 02-03-2015, 03:18 AM
  2. Create orders log and monthly report for all orders
    By adfo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-20-2013, 09:39 AM
  3. [SOLVED] Calculate total dollar amount the is past the past due date
    By Barb1980 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-12-2012, 05:34 PM
  4. Calculate orders past agreed dates in pivot table and averages in pivot tables
    By applesandpears in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 10-18-2012, 05:26 PM
  5. Determining If Occurrences Exist Within Past 30 Days
    By amsnss in forum Excel General
    Replies: 1
    Last Post: 01-05-2012, 05:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1