+ Reply to Thread
Results 1 to 4 of 4

Aging Formula Help

  1. 04-09-2021, 01:54 PM #1
    sss22south
    sss22south is offline
    Registered User
    Join Date
    04-09-2021
    Location
    USA
    MS-Off Ver
    Office
    Posts
    2

    Aging Formula Help

    Hello All,

    I'm new to excel and I was trying to create an aging formula for parts.

    A=Creation Date
    B=Received Date
    C= Open/Closed
    D=Age

    I wanted to see how I could count up the days until the part is received/closed, or it is even possible. I've attached an example.
    Thanks in advance for the assistance.
    Attached Files Attached Files
    Last edited by sss22south; 04-09-2021 at 03:40 PM.
    Reply With QuoteRegister To Reply
  2. 04-09-2021, 02:26 PM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Aging Formula Help

    In D2

    =IF(B2="","",B2-A2)
    Reply With QuoteRegister To Reply
  3. 04-09-2021, 02:28 PM #3
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Aging Formula Help

    I'm not sure what you want but one of these should work:

    =IF(C2="open",TODAY()-A2,"")
    or

    =IF(C2="closed",B2-A2,"")
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  4. 04-09-2021, 03:39 PM #4
    sss22south
    sss22south is offline
    Registered User
    Join Date
    04-09-2021
    Location
    USA
    MS-Off Ver
    Office
    Posts
    2

    Re: Aging Formula Help

    Thanks! That did the trick.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need help on Aging formula
    By vijavad in forum Excel General
    Replies: 2
    Last Post: 08-21-2019, 10:28 PM
  2. Need formula in Aging
    By maya2ph in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-04-2014, 01:21 AM
  3. Formula fo Aging
    By maya2ph in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-03-2014, 10:44 PM
  4. Excel 2007 : Aging formula
    By manishlad in forum Excel General
    Replies: 2
    Last Post: 04-18-2012, 07:35 AM
  5. Aging Formula
    By rashim in forum Excel General
    Replies: 12
    Last Post: 12-12-2010, 10:10 PM
  6. Aging Formula
    By josnah in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-25-2010, 05:25 AM
  7. Aging formula
    By jdmh22a in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-15-2008, 04:39 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1