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

  • Thread starter Thread starter jesco0
  • Start date Start date
J

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
 
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
 
Back
Top