For fun, I'm trying to write a one-cell formula to calculate how many days I have been alive.
My best attempt is [=TODAY()-m/d/yyyy)] which doesn't work.
Thoughts?
TYVM!! Sick
For fun, I'm trying to write a one-cell formula to calculate how many days I have been alive.
My best attempt is [=TODAY()-m/d/yyyy)] which doesn't work.
Thoughts?
TYVM!! Sick
Last edited by sick stigma; 04-09-2024 at 11:23 AM.
Put your data of birth in A2 & useFormula:Please Login or Register to view this content.
Hi there,
If you were born on October 20, 1990 then try:
Hope this helps.Please Login or Register to view this content.
Regards,
Greg M
Bingo!!
Thanks Greg!!
Hi again,
Many thanks for your extremely prompt feedback
You're welcome - glad I was able to help.
Regards,
Greg M
You could also do =TODAY()-"m/d/yyyy"
Looks like I'm invisible again.
Happens to me quite often. I can see you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks