L
Legacy 469343
Guest
Hi everyone,
I hope I can explain in detail, what I need.
Cell J12 reflects the required date of drawing 101 for PO 123456. For this I used the formula: =IF(ISBLANK($B12),"",$B12+14)
Cell J13 needs to reflect the required date of drawing 102, based on the date drawing 101 was sent back to the manufacturer + 2 weeks, which is reflected in cell N12. But still linked to PO 123456. But also only when the status of drawing 101 is status 1.
And above I also need for the next Company / PO 123457.
How can I do this?
Link to Excel file: Sheet.xlsx
I hope I can explain in detail, what I need.
Cell J12 reflects the required date of drawing 101 for PO 123456. For this I used the formula: =IF(ISBLANK($B12),"",$B12+14)
Cell J13 needs to reflect the required date of drawing 102, based on the date drawing 101 was sent back to the manufacturer + 2 weeks, which is reflected in cell N12. But still linked to PO 123456. But also only when the status of drawing 101 is status 1.
And above I also need for the next Company / PO 123457.
How can I do this?
Link to Excel file: Sheet.xlsx