ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Calculate a suspense date of 90 days. (https://www.excelbanter.com/excel-programming/344349-calculate-suspense-date-90-days.html)

Jim Patterson

Calculate a suspense date of 90 days.
 
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

Tom Ogilvy

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




Jim Patterson

Calculate a suspense date of 90 days.
 
Got it. Thanks so much,
V/R,
--
Jim Patterson


"Tom Ogilvy" wrote:

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






All times are GMT +1. The time now is 12:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com