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