Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for updating memberssubscription list annually
I am a secretary for a Pensioners Club in Spain and need a
macro which will flag up when a member's subscription is due ie a year from the date of joining. I am not very au fey with Excel so would appreciate some help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for updating memberssubscription list annually
You can create another column with the renewal date
assume the join date is in column C so for the entry in C2, in D2 (as an example) put in =Date(Year(C2)+1,Month(C2),Day(C2)) or if the renewal is at the end of the month =Date(Year(C2)+1,Month(C2)+1,0) (the zeroeth day of the next month is the last day of the preceding month). using the appropriate formula, you can then select D2 and drag fill down the column. You can then use conditional formatting if you want the dates nearing expiration highlighted. (format=Conditional formatting) -- Regards, Tom Ogilvy "Dawn" wrote in message ... I am a secretary for a Pensioners Club in Spain and need a macro which will flag up when a member's subscription is due ie a year from the date of joining. I am not very au fey with Excel so would appreciate some help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update dates annually | Excel Worksheet Functions | |||
formula to calculate sum of payment increased by 3% annually | Excel Discussion (Misc queries) | |||
quarterly, semi-annually?? | Excel Discussion (Misc queries) | |||
Auto change defined name ranges on Jan 1st annually | Excel Worksheet Functions | |||
List employees with hours worked, weekly, quarterly, and annually | New Users to Excel |