Auto Fill dates in the future

[Judylily]

I have attached a sheet that I need to have some fields auto populate. I have colored them red. Also below I put what dates/time frames I need them to auto populate. Thought maybe that would be easier then trying to explain on this part of the post.

If this is not possible I am open to any ideas. Just an FYI I am going to need to take this information and merge it into a letter. Not sure if that makes any difference.

Kat

[FlameRetired]

I am relying on you to know how you wish to determine fields for the mail merge.

All I have here is the formulas for the dates.

In A3

Please Login or Register  to view this content.

In E3 (this references the date in D one row above)

Please Login or Register  to view this content.

In F3

Please Login or Register  to view this content.

and in N3

Please Login or Register  to view this content.

Fill all of those down the columns.

If you aren't aware of it dates are numbers the formatting is cosmetic. What Excel "sees" is 5 digit numbers like 42824. The formulas will likely return 5 digit numbers. Those will need to be formatted m/d/yyyy.

[Judylily]

I put the formula's in but still have trouble with F3 and N3. See attached.

[JohnTopley]

Perhaps ..
=EDATE(E2,18)

and

=A2+60

in your posted file