HI All,
i need to do a IF formula as shown below. formula is needed in column C as per the description.
can you advise?
thanks
i need to do a IF formula as shown below. formula is needed in column C as per the description.
A | B | C | |
1 | Date | Date+1 | |
2 | 13/12/2023 | A | If b2 = "A" then Display A2 +1 day |
3 | 14/12/2023 | A | |
4 | 15/12/2023 | B | If b4 = "B" then Display "N/A" |
5 | 16/12/2023 | B | |
6 | 17/12/2023 | A | |
7 | 18/12/2023 | A |
can you advise?
thanks