Computing dates

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Just add the number of days ..

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