+ Reply to Thread
Results 1 to 3 of 3

Calculate # of days open with increments of 30, 60 & 90 day values

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    Dallas, Tx
    MS-Off Ver
    Excel 2007
    Posts
    5

    Calculate # of days open with increments of 30, 60 & 90 day values

    I am utilizing the following formula to calculate # of days open

    =DAYS360(K10,IF(M10="",TODAY(),M10))

    I want to return a value indicating the defect has been open 30 days or less, 31-60 days, 61-90 days ... I cannot remember how to do this

  2. #2
    Registered User
    Join Date
    08-13-2012
    Location
    Newark, DE
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Calculate # of days open with increments of 30, 60 & 90 day values

    Does this work for you?

    Please Login or Register  to view this content.
    http://www.mrspreadsheets.com

  3. #3
    Registered User
    Join Date
    08-13-2012
    Location
    Dallas, Tx
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Calculate # of days open with increments of 30, 60 & 90 day values

    I actually finally remembered last night and caluclated it with this formula ...

    =IF(L2<=30,"30 days or less",IF(L2<=60,"31-60 days",IF(L2<=90,"61-90 days", IF(L2 <=120, "91-120 days", IF(L2> 120, "120 + days")))))

    Thanks so much!

+ 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