Good morning,
I need to be able to search an entire row and return the next smallest date. I was originally just using =IFERROR(IF(AND(AJ4>1,AH4<>"N/A"),AJ4-AH4,IF(AND(AJ4>1,AF4<>"N/A"),AJ4-AF4,IF(AND(AJ4>1,AD4<>"N/A"),AJ4-AD4,IF(AND(AJ4>1,AB4<>"N/A"),AJ4-AB4,IF(AND(AJ4>1,Z4<>"N/A"),AJ4-Z4,""))))),"")
I have a long list of steps that have to be completed and between each one I have a days to complete column. The steps are usually done in order but not always and are sometimes done concurrently.
Currently I have it set up using the sample formula above, which would take the date that step was completed and subtract the next date to the left, skipping blanks. I need for the formula to search the whole row and find the next lowest date based off of the date inserted in the column to the formulas left.
I have a sample sheet I can email if needed. Thanks in advance
This is how I want it to read, ignoring blanks:
<TBODY>
</TBODY>
I need to be able to search an entire row and return the next smallest date. I was originally just using =IFERROR(IF(AND(AJ4>1,AH4<>"N/A"),AJ4-AH4,IF(AND(AJ4>1,AF4<>"N/A"),AJ4-AF4,IF(AND(AJ4>1,AD4<>"N/A"),AJ4-AD4,IF(AND(AJ4>1,AB4<>"N/A"),AJ4-AB4,IF(AND(AJ4>1,Z4<>"N/A"),AJ4-Z4,""))))),"")
I have a long list of steps that have to be completed and between each one I have a days to complete column. The steps are usually done in order but not always and are sometimes done concurrently.
Currently I have it set up using the sample formula above, which would take the date that step was completed and subtract the next date to the left, skipping blanks. I need for the formula to search the whole row and find the next lowest date based off of the date inserted in the column to the formulas left.
I have a sample sheet I can email if needed. Thanks in advance
This is how I want it to read, ignoring blanks:
Test | Pop Size | Step 1 | Step 2 | Days to Complete | Step 3 | Days to Complete | Step 4 | Days to Complete | Step 5 | Days to Complete | Step 6 | Days to Complete |
Jan 2014 | 35 | 9/15/14 | 9/16/14 | 1 | 9/19/14 | 1 | 9/18/14 | 2 | 9/25/14 | 6 | ||
Feb 2014 | 88 | 10/1/14 | 10/1/14 | 10/12/14 | 3 | 10/9/14 | 8 | 10/13/14 | 1 | 10/16/14 | 3 | |
Mar 2014 | 47 | 11/6/14 | 11/8/14 | 2 | 11/9/14 | 1 | 11/10/14 | 1 | 11/15/14 | 5 | 11/17/14 | 2 |
Apr 2014 | 36 | 12/1/14 | 12/2/14 | 1 | 12/6/14 | 1 | 12/7/14 | 1 | 12/5/14 | 3 | 12/10/14 | 3 |
<TBODY>
</TBODY>