| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to I calculate 180 days from any date? | Excel Worksheet Functions | |||
| Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| How do I calculate 30 days later from a date | Excel Worksheet Functions | |||
| Calculate # of Days from one date to another | Excel Worksheet Functions | |||
Hybrid Mode
