Forum Discussion
Kybo59
Feb 03, 2023Copper Contributor
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 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??
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")
- Kybo59Copper Contributor
HansVogelaar Thank you ever so much..... You made it look so easy! ....I think that I need to give myself some more training!!!