Cascade IF's

[arogers]

I am trying to use cascading if's to make my spreadsheet more automated. The idea is to automatically update a days pending cell as a project moves through different stages.

Here is my code:

=IF(M17="",DAYS360(L17,NOW()),IF(L17="",DAYS360(J17,NOW()),IF(J17="",DAYS360(H17,NOW()),IF(H17="",DAYS360(F17,NOW()),IF(F17="",DAYS360(E17,NOW()),IF(E17="",DAYS360(D17,NOW()),IF(D17="",D17,DAYS360(D17,NOW()))))))))

D column represents oldest date value and M represents most recent date value.

 

[Ron Coderre]

Column numbers begin with 1 for Col_A and increment across columns to the right.
Col_A = 1
Col_B = 2
etc.

So, in the formula I posted, this section: MATCH(COLUMN(D17:M17),{4,5,6,8,10,12,13},0)
Checks if the column number for each cell in D17:M17 is on our list of columns we're interested in checking.
ColNum 4 = Col_D
ColNum 5 = Col_E
ColNum 6 = Col_F
ColNum 8 = Col_H
ColNum 10 = Col_J
ColNum 12 = Col_L
ColNum 13 = Col_M

Does that help?