•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Microsoft Excel keeps calling me a liar
I have a spreadsheet where I keep track of the birthdays and current ages of my family members. For example, my dad’s D.O.B. is 6/9/34. He is 91 (he’ll turn 92 this June) – but Microsoft Excel keeps insisting in the “Age” field (B6) that he’s 89. The formula I have in that cell is as follows:
=DATEDIF(B6,TODAY(),"Y")
(Note: Cell B6 is formatted as a Date. I changed it to General and then back to Date and it made no difference.)
Any ideas?! I’ve been sober for 19 years and that number is gonna change to “about 30 minutes” very soon!
Thanks
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#AI formula generation techniques
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#Microsoft Excel
#spreadsheet
#birthdays
#ages
#D.O.B.