Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reminder in excel
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reminder in excel
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 horseman wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reminder in excel
Thanks it works ok
"Pete_UK" wrote: 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 horseman wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract MS Excel Data embedded in MS Word | Excel Discussion (Misc queries) | |||
Cell shows date, want to email from excel to me as a reminder | Excel Discussion (Misc queries) | |||
Can excel send reminder emails on dates entered in a wookbook? | Excel Discussion (Misc queries) | |||
Format Excel column to notify with a reminder | Excel Worksheet Functions | |||
Format Excel column to notify with a reminder? | Excel Discussion (Misc queries) |