Add number of days to date based on a condition

[SKirkaldy]

Are you able to help, I have a starting date of 07/06/2017 in cell H4, I then want to add the number of days which is in columns C but only if there is a Yes in column D, this works but not if there is a NO. If there is a No, I want it to look at the last date that was calculated e.g. 14/06/2017 and then carry on. I have attached the file.

[Aardigspook]

You just need to add the [value if false] condition to your formula:

Please Login or Register  to view this content.

[SKirkaldy]

Thank you

If I add a false of H4, then the date gets repeated e.g. 14/06/2017, I don't want anything to appear in the cell, how can I do this?

[SKirkaldy]

I have attached the file again.

[Aardigspook]

Ah, sorry, I misunderstood and thought you wanted the date repeated.

This will do what you want, I think - enter it in H5 and drag down:

Please Login or Register  to view this content.

[SKirkaldy]

Great, thank you so much.

[Aardigspook]

You're welcome.

If that takes care of your original question, then please take a moment to mark the thread as Solved so others know there's an answer here (instructions are in my sig). Thanks.