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
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
Does this work for you?
Please Login or Register to view this content.
http://www.mrspreadsheets.com
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks