thank you, btw your cursor blocks the formula making it less visible, if you can make it more transparent that would be great, or maybe just use an arrow
Now, just for interest sake I want to know how often this method would be wrong. One example would be anyone who just turned one in a non-leap year. You'd be dividing by 365 by 365.25, and get less than one. This would int() to 0. When it was their birthday and they were actually 1. (Your automated birthday message could be a day late!) Second question is, is there a simple way to always get it exactly right?
Another example of how dated and lack of user friendly options in Excel. Instead of having to write a formula, why not a command where you can simply select the 2 cells with the start and end date
You're teaching me chemistry, physics, math, and IT. You're amazing keep up the good work.
man is completing all the side missions
With the max score too!
🤣🤣100% completion… OCT the 🐐🐐🐐
That we call *PRO GAMER*
Hoping that one day we will get a stream of Biochemistry videos from the legend himself.
it doesnt work for me it says #value error
You literally teaching me everything😭
excel is so confusing so this was helpful😭 thank you Husband 💘
not the husband LMAO
@@hannahrepollo PLEASE
@@ritajabal FACTS THO 😍
but what if the other way around. the age is given and how to determine the birthdate
sir why there is error if the year wa start at 1800?
This is an interesting video to make
thank you, btw your cursor blocks the formula making it less visible, if you can make it more transparent that would be great, or maybe just use an arrow
Now, just for interest sake I want to know how often this method would be wrong. One example would be anyone who just turned one in a non-leap year. You'd be dividing by 365 by 365.25, and get less than one. This would int() to 0. When it was their birthday and they were actually 1. (Your automated birthday message could be a day late!)
Second question is, is there a simple way to always get it exactly right?
Another example of how dated and lack of user friendly options in Excel. Instead of having to write a formula, why not a command where you can simply select the 2 cells with the start and end date
My DOB1-1-1944 when I will reach 80 years of age
Hello