Reminder in excel

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

Guest

I have put our subscriptions folder in to excel 2000. This consists of name
of publication, date received, order no, invoice no., price and date of
renewal, these are put in different worksheets under the publishers. The
first worksheet is the index and I have used hyperlinks to link to the
publications. Is it possible to do a reminder so that it will let me know
when the publications are up for renewal.
 
Assuming your renewal date is in column F, starting on row 2, you could
make use of a helper column to put this formula in cell G2:

=IF(F2<TODAY()+30,"Time to renew","")

and copy this formula down as necessary. This will give you a reminder
30 days in advance.

Another approach would be to apply conditional formatting to the
renewal dates, so they change colour as you get within 30 days.

Hope this helps.

Pete
 
Thanks it works ok

Pete_UK said:
Assuming your renewal date is in column F, starting on row 2, you could
make use of a helper column to put this formula in cell G2:

=IF(F2<TODAY()+30,"Time to renew","")

and copy this formula down as necessary. This will give you a reminder
30 days in advance.

Another approach would be to apply conditional formatting to the
renewal dates, so they change colour as you get within 30 days.

Hope this helps.

Pete
Click to expand...
 

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

can I create outlook reminders from worksheet data? 1
Reminder 1
MS Access setting outlook reminders from a DAO recordset 0
Outlook Macro to set Reminder on a Contact tomorro 9:00 4
Outlook Outlook 2010: Reminders in a calendar of a public folder 0
Excel Automatic Email Alerts 3
Reminders in Excel 1
Can Word automatically send reminders on specific future dates? 3

Back
Top