mattkorguk
Registered User.
- Local time
- Today, 20:19
- Joined
- Jun 26, 2007
- Messages
- 301
Hi all,
I'm working on something for a school that holds children's ages in year.month format. Following tests, their 'test' age is recorded in the same format. All they want then is a progress column which calculates the two fields, simple.
I'm currently using the following to get their 'age at test date';
(Where B3 is their DoB and D3 is the test date)
If their DoB is 01/02/2007 the above shows 8.10 if the test date was 01/12/2015, seems ok.
When the teacher adds a test score age of 8.4, when you try and take one from the other, obviously Excel thinks it's decimal and returns 0.3. (-0.6 required)
Any suggestions much appreciated, thanks.
I'm working on something for a school that holds children's ages in year.month format. Following tests, their 'test' age is recorded in the same format. All they want then is a progress column which calculates the two fields, simple.
I'm currently using the following to get their 'age at test date';
Code:
=DATEDIF(B3,D3,"y") & "." & DATEDIF(B3,D3,"ym")If their DoB is 01/02/2007 the above shows 8.10 if the test date was 01/12/2015, seems ok.
When the teacher adds a test score age of 8.4, when you try and take one from the other, obviously Excel thinks it's decimal and returns 0.3. (-0.6 required)
Any suggestions much appreciated, thanks.
