Forum Discussion
Solved
Resorting Data
I have a simple spreadsheet that lists, names, date of birth, current age etc. e.g. All works well, using the hidden column containing 'today', which calculates the age of each entry on the d...
HansVogelaar Thank you ever so much..... You made it look so easy! ....I think that I need to give myself some more training!!!
Let's say the date of birth data are in E2, F2 and G2 and today's date in H2.
=DATEDIF(DATEVALUE(E2&" "&F2&" "&G2),H2,"Y")
HansVogelaar Thank you ever so much..... You made it look so easy! ....I think that I need to give myself some more training!!!