View Single Post
  #3   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

macheath48,

=A2+60

and format the cell as a date.

--
HTH,
Bernie
MS Excel MVP


"macheath48" wrote in message
...
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?