Feb 03 2023 04:49 AM
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 day that I open/print the sheet.
However, I have been trying to find a way which will 'block' the data by Month for a list in date order, but because the date contains the year, I cannot sort by just month, hence v2
..... Now, I cannot figure out a way in which I can reformulate the data to report the correct current age? ..... Any help please??
Feb 03 2023 04:59 AM
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")
Feb 03 2023 10:57 PM
Solution@Hans Vogelaar Thank you ever so much..... You made it look so easy! ....I think that I need to give myself some more training!!!
Feb 03 2023 10:57 PM
Solution@Hans Vogelaar Thank you ever so much..... You made it look so easy! ....I think that I need to give myself some more training!!!