Calculating Days in Excel 97

  • Thread starter Thread starter dluhyt
  • Start date Start date
D

dluhyt

Can someone tell me how to project a date in the future
given a specific number of days? eg: Today is July 29,
2003, what date will it be 199 days from today's date.

Thanks
 
NB - TODAY() and NOW() are volatile functions ; they constantly update as
per your system date/time.

If you use TODAY(), it will return 29 July ; come back to the file tomorrow
and it'll return 30 July. If this is what you need, fine ; if not (project
planning perhaps), use the actual date.

Rgds,
Andy
 
Yeah if cell A1 contained the date 29/07/03, then in say
cell a2 use the formula =A1+199 as Excel ad this figure
as days and format cell in a date format
 
Back
Top