Forum Discussion

Brieloggia42's avatar
Brieloggia42
Copper Contributor
Sep 24, 2023

Auto populate due dates based off of kick off date

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

excel
Formulas and Functions
training

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Sep 24, 2023

    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.

Resources