Calculating Remaining Years, Months, Days left....

[gymwrecker]

I need help with a formula that can determine the number of years, months, and days that are left from today before reaching a specific date in the future?

A1 = 2024/08/23
B1 = (years,months.days) left based on today's date.

Any help is greatly appreciated!

 

[Dan_W]

How would you want the information in B1 to be presented? A basic formula of:

=A1-TODAY()

will show you the number of days between the date in A1 and 'Today', but requires a bit more finessing to give months/years too - but depends on how you would want it to look.

 

[gymwrecker]

Thank you Dan! It works fine for now...

 

[Dan_W]

LOL - "... for now ..." sounds rather ominous!
It's entirely possible to work some math on the resulting number of days to convert it into years, months, etc, it just depends on how you'd want it to be presented.

 

[gymwrecker]

My apologies Dan! I didnt mean it that way…The formula =A1-TODAY ( ) returns the total number of days which works for me; what I was initially looking for was for a formula to return the number of years, months, and days remaining from the date in A1

Dan, again, Thank you! I greatly appreciate all the help!!!!

 

[Dan_W]

That's ok. I thought it sounded funny, is all. I wasn't at all upset.
Glad it's working for you, but do please let me know if you'd like help adjusting it at all.