ExcelBanter - How to put todays date in one cell then the next cell adds x days

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to put todays date in one cell then the next cell adds x days (https://www.excelbanter.com/excel-discussion-misc-queries/63451-how-put-todays-date-one-cell-then-next-cell-adds-x-days.html)

trekkies

How to put todays date in one cell then the next cell adds x days

What formula do I need to allow me to enter a date (todays) in one cell the
the next cell will give me a date x days into the future

answer via

bob

Fred Smith

How to put todays date in one cell then the next cell adds x days

Cell one: =Today()
Cell two: =C1+x

--
Regards,
Fred

"trekkies" wrote in message
...
What formula do I need to allow me to enter a date (todays) in one cell the
the next cell will give me a date x days into the future

answer via

bob

All times are GMT +1. The time now is 05:49 AM.