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 |