Help

[caddersmixfm]

I have a cell which I have name 'start date'. This is the date that a particular person has started there employment. There are then lists of vaarious training, which get a 'y' for yes, completed, or a 'n' for no, not completed.After this cell, there is another cell which, if there is a 'y' in the cell before, will say when a check up is needed on the training. i.e start date is the 1st of march, check up needed between the quarter of april-june. all checking up is done in quarters starting with the month after the startdate.

i.e
start date - june 1st, checkup july-september.

Can someone give me aformula that will allow this cell to be automatically populated by using the start date and whther there is a 'y' or 'n' present.

Many Thanks

[ken2step]

=IF(F14="Y",TEXT(EOMONTH(E14,1),"mmm")&" - "&TEXT(EOMONTH(E14,3),"mmm"),"Not completed")

with Cell E14 holding your start date and Cell F14 holding your "Y" or "N".

Ken

[onlyadrafter]

Hello,

First of all, please don'r put HELP as the subject, give a little description.

Have found a workround, but there may be a formula will take a look later.
What I suggest is to use VLOOKUP so
cell A4 = 1/6/04
cell B5 = y or n

in cell C4 enter this formula

=IF(B4="y",VLOOKUP(MONTH(A4),$I$4:$J$15,2),"")

where I4-J15 is the following table

I4 = 1; J4 = February-April
I5 = 2; J5 = March-May
..
I15=12; J15 =January to March

Change the cell refs as required.

Is this OK?

EDIT:

Nice one Ken2Step, beat me to it and much better!