How to add and update Expiry Date Column?

[saqi2000]

Dear Tekkies,

Hope all is well and you are enjoying the summer.

I am novice user of Excel and I have to perform a complex task and hope you can help me with that.

I have been handed over Membership responsibility for our organisation and it's Membership database is not very good state. Please find the details below:

It's in Excel format
It has 7000 Members
There is no title field in the database and I would like to add the title field based on relationship field that starts S/O, D/O, W/O
S/O = Son Of
D/O = Daughter of
W/O = Wife of

Based on info ib Relationship field I would like to update title field to the following values:

Mr
Miss
Mrs

Second Question is a bit complex

The database does have Membership joining date but expiry column is blank.

There are 6 different types of Memberships but I only would like to add expiry date for annual Membership. Where Membership_Type="Annual Membership"

For example, if someone joined on 1st April 2011, his/her Membership would expire on 31st March 2012

Please advise how can I do this?

Kind Regards




Knowledge is something no one can steal from you and it increase as time goes by. Saqi

 

[SkipVought]

Hi,

In both Questions, you should use an IF() function. Do you know how the IF() function works?

In the first case, you will need two nested IF() functions, structured like this, but referencing the appropriate cells
[tt]
=if(s/o cell<>"","Mr.",if(d/o cell<>"","Miss","Mrs."))
[/tt]
The other you'll do a similar thing referencing the Membership_Type
[tt]
=if(mem typ cell="Annual Membership",date(Year(join dt cell)+1, month( join dt cell), day(join dt cell))),"")
[/tt]
The date formula wll probably need to be tweaked.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}