Computing dates

G

Guest

I would like to compute a date say 10 days from 1/1/2004.
Using the workday function it will return 15/1/2004 which
has computed 10 working days from 1/1/2004. How do I
formularise the cell to return the date as 11/1/2004 (ie
10 calender days and not working days)?

Help greatly appreciated
 
M

Max

Just add the number of days ..

Example:
Put in B1: =A1+10
If A1 contains: 1/1/2004, B1 will return: 11/1/2004
 

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

Top