How to calculate a person's NEXT age rather than current age?

[melissarose]

I wanted to make a table alongside my personal budget showing me when each person's birthday is and how old they are next going to be, since I always forget. I can get their current age by using the formula =DATEDIF(A1,TODAY(),"y")

I tried just changing it to =DATEDIF(A18,TODAY(),"y")+1 but it changed to a random date (07/02/1900) instead of an age!

I'm a total beginner so any advice would be great, thanks!

 

[Andrew Poulsom]

Welcome to MrExcel.

Format the cell as General.

 

[steve the fish]

Just format that cell to general

 

[Special-K99]

=TEXT(DATEDIF(A1,TODAY(),"y")+1,"0")

but that's now text rather than a number

 

[melissarose]

Oh my god thanks, it's working now