Need help on Aging formula
Results 1 to 3 of 3

Thread: Need help on Aging formula
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2017
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Need help on Aging formula

    Hi Folks,

    I have 3 columns wit different dates and i want to write a formula in 4th column and my condition is to calculate the aging whichever is the latest date among the three columns.

    Formula needs to calculate aging from =TODAY()- Latest among the 3 columns dates.

  2. #2
    New Member
    Join Date
    Aug 2019
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need help on Aging formula

    Try
    =TODAY()-MAX(A2:C2)

  3. #3
    New Member
    Join Date
    May 2017
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Need help on Aging formula

    Paul really appreciate for your help and swift response . Thank U SO MUCH

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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