How to set up past due notices based on dates

L

Linn

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?
 
B

Biff

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-30>TODAY(),"",A1-TODAY()&" day"&IF(A1-TODAY()
1,"s","")&" until due"))))
Click to expand...

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
 
L

Linn

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.
 
Top