Reminder

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

Guest

I have put our subscription in excel. I have a column for the description
and a column for the price and column for the month the subscription is due.
Is their any way that I can set a reminder to let me know when the
subscription is due? I am using excel 2000
 
Assuming Date in column C; in D1 enter
=IF(C1<TODAY(),"Overdue",IF(C1-TODAY()<30,"Due",""))

Also consider using Format | Conditional Formatting to colour the row red
when overdue and blue when due. Select all the data; use Conditional
Formatting with
Formula Is: =$D1="Overdue", then format patter/fill to red
add another for "Due"

best wishes
 
Back
Top