SOLVED

Resorting Data

Copper Contributor

I have a simple spreadsheet that lists, names, date of birth, current age etc. e.g. 

Kybo59_0-1675428122272.png

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

Kybo59_1-1675428453774.png

..... Now, I cannot figure out a way in which I can reformulate the data to report the correct current age? ..... Any help please??

 

2 Replies

@Kybo59 

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")

best response confirmed by Kybo59 (Copper Contributor)
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!!!

1 best response

Accepted Solutions
best response confirmed by Kybo59 (Copper Contributor)
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!!!

View solution in original post