Anyone good with excel?

[pooley]

The HT has asked me to produce a template that works out the chronological age of a child and then when the reading age is entered will work out the difference.

I have robbed some code from another chronological age calc but it's not what the Head wants, he would like to see the age as a decial, i.e. 6.04 would be 6 yrs 4months.

 

I have attached the doc I am playing with, any pointers would be appreciated.

 

Thanks

 

Sireading age blank.xlsx

[localzuk]

It isn't a real decimal then, as 6 years 4 months would be 6.333 Recurring.

 

I'd suggest the formula

 

=DATEDIF(B3,D3,"y") & "." & DATEDIF(B3,D3,"ym")

 

This would give you your year.month idea.

[pooley]

Thanks, I realize that Decimals and months isn't a great idea, but since when do teachers worry about that ?

[pooley]

[ATTACH]12739[/ATTACH]OK got it working, anyone know how I can format the last column to show if the difference is a posistive or negative, -6 or +1.1 etc ?

At the moment it shows the difference but doesnt display if its a negative number or not.

reading age Copy.xlsx

Edited January 17, 2012 by pooley

[bladedanny]

[ATTACH]12739[/ATTACH]OK got it working, anyone know how I can format the last column to show if the difference is a posistive or negative, -6 or +1.1 etc ?

At the moment it shows the difference but doesnt display if its a negative number or not.

 

Just remove the ABS from your last column to leave E3-F3 etc. Wouldn't that work?

 

EDIT -- If you want the difference to be how many years older their reading age is from their actual age swap the formula around eg F3-E3

 

Hope this helps.

Edited January 17, 2012 by bladedanny

[pooley]

Doh, spot the bleeding obvious, thanks mate

[bladedanny]

No Problem