Hi
I need the value in B column to be update in C column if the Date is matching with in the range A4:A22
I need the value in B column to be update in C column if the Date is matching with in the range A4:A22
| condition 1 | Cell E2 should match with date in the range A4:A22 |
| condition 2 | if Condition 1 meets, then subtract E2 from F1 and the resultant date should match with in the range A4:A22 |
| Condition 3 | if condition 2 meets, value in B column against the condition 2 output should update in column C in the same row |