Date auto populate with changing construction stages?

[aking@citysidehomes.com]

I am trying to create a cell that auto populates as construction dates are added and updated. So if stage one has a date then the prjoected date would be stage one date plus 126 days. If stage 2 is not null, then the projected would be stage 2 plus 119 days, and so on. I cant even get a date to pull for stage one

[ranman256]

in a query or the form:
=DateAdd("d",126,[Stage1Date])

=DateAdd("d",119,[Stage2Date])

the Stage1Date should be automatically filled in the form: default = Date()
when user enters the data.

[Welshgasman]

I would put those date periods into a config table and look them up, just in case your date period can change. That way you just change data and not have to recode.
For days you can just do simple math and add the days

? date +10
13/10/2023

However if you can always calculate them, then they should not be stored, unless the range might change?

[aking@citysidehomes.com]

Thank you! I have it pulling in a date, but they all say 12/30. Here is the expression so far.

=DateAdd("d",126, [ProductionQry2 Closings].[Projected Start Date])=DateAdd("d",119, [ProductionQry2 Closings].[Stage 302 Date - Frame Complete])