Forum Discussion
Solved
Formula Help
Hello, I am working on a project and using excel to forecast and track milestones. I am looking for a formula that will add 7 days to another cell, unless another cell has a date, then add 7 days to ...
- Assuming your first row of data begins in cell A4, the task 2 forecast formula in column C4 could be:
=IF($B4>””, $B4+7, $A4+7)
Charla74 THANK YOU!!!! That works perfectly... You saved me a concussion from banging my head to figure it out. SO the >"" is what points to the blank cell? If I wanted it to look for a 5, I would put >"5", correct?
Exactly. >”” is looking for anything other than a blank cell and, as you say >5 would be any number, 6 or above.
Happy I could assist.
Happy I could assist.