Forum Discussion

Kybo59's avatar
Kybo59
Copper Contributor
Feb 03, 2023
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 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??

 

  • Kybo59's avatar
    Kybo59
    Feb 04, 2023

    HansVogelaar Thank you ever so much..... You made it look so easy! ....I think that I need to give myself some more training!!!

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

    • Kybo59's avatar
      Kybo59
      Copper Contributor

      HansVogelaar Thank you ever so much..... You made it look so easy! ....I think that I need to give myself some more training!!!

Resources