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

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

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

If you want 28 days after today, =TODAY()+28, but that would not be 19th
June.
--
David Biddulph

"jesco0" wrote in message
...
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

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

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

On May 19, 7:55*am, jesco0 wrote:
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