How to set up past due notices based on dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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-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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Dates with the IF function 2
Excel Formula - Count Dates from another Sheet 8
Outlook Macro to set Reminder on a Contact tomorro 9:00 4
Emailing formula results 1
Conditional Formula based on previous date + 30 1
How do I set up Alerts and Notification on Excel? 1
Notices from Excel to Outlook? 1
Excel Excel due and overdue date colours 2

Back
Top