how do I make excel automat gener8 the date for 28 days l8a?

[jesco0]

I want to make excel automatically generate a future date based on the date
day e.g today is the 19th but i want excel to generate 28 days later so the
date would be 19th june

 

[Pete_UK]

28 days beyond today would not give you 19th June. Assume your
starting date is in A1, then try this:

=A1+28

Format cell as a date. If you just want 28 days from today's date:

=TODAY()+28.

Hope this helps.

Pete