Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
new to excell
i have a gym with several members. what i want to do is create a formula that
will tell me when the membership expires. for instance at the side of each name there will be a cell with current or expired so i will know at a glance who has to renew. Unfortunately, there are weekly, monthly, quarterly and yearly memberships. Can you help me???? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
new to excell
Even though the memberships can be purchased in a variety of different time
intervals, it is MUCH easier to uses days exclusively. Say the name is in column A, the membership start date in column B and the duration in days in column C. The in column D we use =B1+C1 and format as date. Column D will have the expirations date. For example: James Smith 12/24/08 43 02/05/09 John Johnson 10/19/08 7 10/26/08 Robert Williams 10/28/08 92 01/28/09 Michael Jones 11/14/08 82 02/04/09 William Brown 11/04/08 69 01/12/09 David Davis 12/10/08 69 02/17/09 Richard Miller 11/05/08 75 01/19/09 Charles Wilson 10/24/08 11 11/04/08 Joseph Moore 11/18/08 91 02/17/09 Thomas Taylor 11/21/08 57 01/17/09 It is pretty obvious who has already expired. -- Gary''s Student - gsnu200826 "Trudi in the BVI" wrote: i have a gym with several members. what i want to do is create a formula that will tell me when the membership expires. for instance at the side of each name there will be a cell with current or expired so i will know at a glance who has to renew. Unfortunately, there are weekly, monthly, quarterly and yearly memberships. Can you help me???? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
new to excell
Hi
And if you like Gary's Student idea you can also say 5 days or any amount of days before expiration date, have that cell turn red or any colour by going to FormatConditional FormattingSelect "Less Than" in second box, third box put number you likepress Format botton, Patterns Select colour. HTH John "Trudi in the BVI" <Trudi in the wrote in message ... i have a gym with several members. what i want to do is create a formula that will tell me when the membership expires. for instance at the side of each name there will be a cell with current or expired so i will know at a glance who has to renew. Unfortunately, there are weekly, monthly, quarterly and yearly memberships. Can you help me???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto locking of excell workbook (excell 2003) | Excel Discussion (Misc queries) | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
create a slides show with excell spreadsheets using excell | Charts and Charting in Excel | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
how do you open an excell email attacment, if I dont have excell | Excel Discussion (Misc queries) |