returning dates

[John]

Hi,
I teach musical instruments. We have a grade system and it is expected that
pupils reach a certain grade in a certain amount of time.

By inserting the start date (mm/yy) of a pupil is it possible to generate
the expected date - with reference to the report date i.e. todays date.

e.g. start date of 10/03 it is expected that a pupil be at Grade 1.

When I insert the start date could excel generate:

Expected standard after *21* months is *grade 1*

Oh - and I'm trying to get this to work in word - as we need to add
comments. worth trying?

Any thoughts

 

[Bill Kuunders]

John
set up a small table of expected levels after certain months
for example in cells M1 to N6

0 student
6 level1
12 level2
18 level 3
21 grade1
29 grade 2

name in B2
start date in C2
today's date =today() in cell K1
the difference in months in cell D2 =($K$1-C2)/30.4
enter in cell E2 =VLOOKUP(D2,$M$1:$N$6,2,TRUE)

you can extend the last two formula's down the column.
go to the bottom right hand corner of the cell
the mouse pointer will change to a "+" sign
click and drag down.....

you can add comments in any cell
I do not know how to use these formula's in "word"

good luck