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

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