Populating a year chart with a persons age

[Ocean525]

I would like help to create a column of of dates (month and year) that I can also minimize to just year. Then I want to put a persons age in the next collum and have is populate down showing the persons age relatice to the date, EG: 2024/56
2025/57
2026/58
I would need a another column to add another person's age to populate the same
2024/56/51

I must be honest I don't know where to begin but once I read the code I'm sure it will all make sense.

 

[Ocean525]

I will paste it in. Is that a book that has formulars that I can read, learn and copy that is not bogged down and makes scense for the non mathamatical genius that you would recomend. Something like a dictionary, I look up what to accomplish and wow there it is a formular?

 

[Ocean525]

OPPS that did not work all I got is the entire chart turns to #VALUE for date and age cells.

 

[Gerald Higgins]

Well there are plenty of books, but in my experience you rarely find something in a book that EXACTLY matches what you're trying to do.
The best thing in my opinion is learning on the job.
Have a look at the formulas I've posted, tinker round with them, and try to understand how they work.
Also have a look at Excel help, it can sometimes be helpful (though sadly not always !)

 

[Ocean525]

yea I catching on the "" is nothing so if A3="","") if a3 has nothing in it return nothing-leave blank. I do love this and the potential to create. problem is time!

 

[Gerald Higgins]

OPPS that did not work all I got is the entire chart turns to #VALUE for date and age cells.

That's not what I got.

In A3, use the formula from today's post.
In B3, use the formula from my last post yesterday.
Copy both A3 and B3 down as far as required.

If there is nothing in A1:B2, then the rows below are blank (for me!)
If I put something in A1, and leave A2:B2 blank, the rows below remain blank.
If I put something in A2, and leave A1 and B2 blank, the rows below remain blank.
If I put something in B2, and leave A1:A2 blank, the rows below remain blank.

 

[Ocean525]

I changed it to =IF(E3="","",IF(F2="","",F2+1)) and it does what I need. Could not have done it with out your help. Thanks I learned something new and exciting.

 

[Ocean525]

That didn't quite work but this does:=IF($A3="","",IF(B2="","",B2+1)) lol