Hi Folks
I'm from decidely damp Dorset though it's still beautiful.
I have created a column that displays a real time age based on system date. Date of birth is subtracted from the system 'now' and displays the age. What I need to do is calculate different age ranges within that column so that for all those aged 16-17 return a result in one exterior cell, those aged 18-21 return a result in a seperate cell, those aged 22-24 return a result in another cell and so on.
Column A is: =NOW()
Column E is =(A4-D5)/365
With Column D serving as input for date of birth
Hope someone can put me right...
Cheers fellas
:-)
Martin
Bookmarks