How to set up past due notices based on dates
 

How can I use a date function to setup a past notice when a date expires? A
second question is how to set up a date function that gives a notice prior to
the expiration date say 30 days prior?

"Gives a notice" Please define what you mean by "give a notice".

****************
Anne Troy
www.piersontech.com
www.mrexcel.com


"Linn" wrote in message
...
How can I use a date function to setup a past notice when a date expires?
A
second question is how to set up a date function that gives a notice prior
to
the expiration date say 30 days prior?

Hi!

Here's something that you can try.

Assume cell A1 is the due date.

=IF(A1="","",IF(A1=TODAY(),"due today",IF(TODAY()A1,"PAST
DUE",IF(A1-30TODAY(),"",A1-TODAY()&" day"&IF(A1-TODAY()
1,"s","")&" until due"))))

This will give you a "count down" once the due date is 30
days or less: 13 days until due

On the due date it will return: due today

After the due date it will return: PAST DUE

Biff

-----Original Message-----
How can I use a date function to setup a past notice when
a date expires? A
second question is how to set up a date function that
gives a notice prior to
the expiration date say 30 days prior?
.

The gives a notice means that 30 days before the due date arrives, give me a
flag or notice that the due date will arrive in thirty days. My intention is
to send reminders out before the due date is met.
"Linn" wrote:

How can I use a date function to setup a past notice when a date expires? A
second question is how to set up a date function that gives a notice prior to
the expiration date say 30 days prior?