Calculating Days in Excel 97

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
 
A

Andy Brown

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
 
P

phill

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

days calculation 2
Days culculation 5
Excel Excel Show Countdown Date 7
Future date Calculation 8
how to calculate hrs flown in last one year 0
Counting Days 5
How to calculate with workingdays instead of calendar days 4
Trailing 30 days sum calculation with excel 1

Top