Auto populate due dates based off of kick off date

[Brieloggia42]

Hey everyone

I'm not 100% the best with excel so there may be a quick link somewhere to my question.

I am creating a project tracker. The day that I start the project tracker, i need certain tasks to have dates auto populated off of that date. I have tried my best but it seems that if I don't have the kick off date populated ( for my template ) then the rest of the dates that would be auto populated just stay as ####.

I am sure there is an easy solution i just havn't had as much experience.

Thanks in advance

[#2]

@Brieloggia42 

Let's say you enter the start date in D2 and down.

If you want to refer to that date in a formula in another cell, use something like this:

=IF(D2="", "", your expression referring to D2 here)

If you'd like more specific help, please provide details about your formulas.