View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Calculate a suspense date of 90 days.

suspense = orgdate + 90

Dates are stored as the elapsed number of days from a base date, so just
adding 90 to it should be 90 days later.

Ron de Bruin has all kinds of sample code on sending emails:

http://www.rondebruin.nl/sendmail.htm

--
Regards,
Tom Ogilvy

"Jim Patterson" wrote in message
...
Hello,
I am trying to figure out how to calculate a suspense date of 90 days from
the original date, and if possible send an email alert notifying me of the
event.

Thanks in Advance,
--
Jim Patterson