Results 1 to 3 of 3

formul help to calcaulte the aging with two column under criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-23-2013
    Location
    bangalore
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    143

    formul help to calcaulte the aging with two column under criteria

    hi excel experts

    i looking for some result from two column

    like A and B have dates column named A as SUBMIT AND B as RECEIVED

    1. If No Date In Sumit And Date Is In Received Means Result Blank
    2. If Date In Submit And No Date In Received Means Result Aging With Today Date
    3. If Date In Submit And Received Also Result Aging Between Submit And Received
    4. If Both Column Blank Result Blank

    here formula before logica test,

    for 2 result CLEAN(IF(TODAY()-AA7>=30,">30 Days",IF(TODAY()-AA7>20,"21-30 Days",IF(TODAY()-AA7>15,"16-20 Days",IF(TODAY()-AA7>10,"11-15 Days",IF(TODAY()-AA7>5,"6-10 Days",IF(TODAY()-AA7>3,"3-5 Days","0-2 Days")))))))

    for 3 result CLEAN(IF(AA7-AB7>=30,">30 Days",IF(AA7-AB7>20,"21-30 Days",IF(AA7-AB7>15,"16-20 Days",IF(AA7-AB7>10,"11-15 Days",IF(AA7-AB7>5,"6-10 Days",IF(AA7-AB7>3,"3-5 Days","0-2 Days"))))))))


    find the attachment... you understand than me....
    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. [SOLVED] Aging calculate with column a or b depends upon condition
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-03-2013, 01:28 PM
  2. Replies: 8
    Last Post: 07-11-2013, 01:53 AM
  3. [SOLVED] aging a date in column A unless there is a value in column B
    By tylerf in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-05-2013, 01:39 PM
  4. Using SUMIF function with multiple criteria for Aging
    By josnah in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-04-2006, 05:25 AM
  5. Replies: 1
    Last Post: 02-05-2006, 01:55 PM

Tags for this Thread

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