View Single Post
  #2   Report Post  
Adrian M
 
Posts: n/a
Default

If you want you can just add 60 to the cell containing the date and just make
sure it is formatted as a date. Alternatively you can use the EDATE. You can
see how to use EDATE on http://www.auditexcel.co.za/date.html .

"macheath48" wrote:

I need to add 60 calendar days to the current date in an EXCEL worksheet
(i.e., August 1, 2005 + 60 calendar days) so I will know when to send out a
second notice.

I tried putting the current date in cell A2 and using the formula
=workday(A2+60) but I get an error message. Does anyone know the correct
formula to use?