+ Reply to Thread
Results 1 to 2 of 2

A/P aging with date in IF statement

  1. #1
    Registered User
    Join Date
    10-21-2009
    Location
    Ada, OK
    MS-Off Ver
    Excel 2007
    Posts
    2

    A/P aging with date in IF statement

    Need a formula to enter invoice amount in correct aging column by comparing invoice date to a random date entered in cell A1 to determine days outstanding. See attached worksheet.
    Attached Files Attached Files
    Last edited by rbray; 01-07-2010 at 01:16 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    08-23-2009
    Location
    Hampshire, UK
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    328

    Re: A/P aging with date in IF statement

    You could use in G7
    Please Login or Register  to view this content.
    and in H7
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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