Age Formula
I have a calories-burned-daily spreadsheet formula that I made for the sake of calculating calories burned both during the day and during special exercise such as jogging. So for it to be as accurate as I could manage, I also made up a spreadsheet formula for calculating a person’s exact age. So for anybody interested, it is as follows:
=(YEAR($B4540)-(YEAR($B$2)+1))+((DATEVALUE(CONCATENATE("01/01/";TEXT(YEAR($B$2)+1;"0")))-$B$2)+($B4540-DATEVALUE(CONCATENATE("01/01/";TEXT(YEAR($B4540);"0")))))/(DATEVALUE(CONCATENATE("01/01/";TEXT(YEAR($B4540)+1;"0")))-DATEVALUE(CONCATENATE("01/01/";TEXT(YEAR($B4540);"0"))))
This formula is written for an old Star Office spreadsheet program that I have, although it isn’t really that different from other spreadsheet formulas with likely only some of the spelling for some of the functions perhaps being a bit different. And at $B$2 is where the person’s Birthdate is placed for the sake of this formula, which mine happens to be 12/29/1957. And the reference to $B4540 above is the current row that I just happened to be on at the time that I copied this for this post, with the $B column part of it pointing to the cell that contains today’s date on the same current row, with this formula of course being placed in a different cell on the same row so that it shows the exact age that is at that exact date. And I’ve got my cell-view of my age set to a Number type having 3 decimal places, with my present age therefore showing as 59.271 years old as of today, 04/07/2017. And along the lines of aging, let it be known that my darn eyes have been falling apart lately due to aging, with PVD’s having first effected my left eye recently and now with one effecting my right eye as well, which is where the posterior vitreous in the eye detaches from the retina and appears in the vision as annoying floaters of all sizes and shapes. It’s so sad because up until about a week and a half ago I didn’t have any spots in my right eye’s vision whatsoever. But now, it’s like constantly having to look through a dirty lens that I’d just LOVE to clean--especially with my being a perfectionist--but CAN’T!!! Soooooooooooo...BLAH!!! So aging kind of sucks BIG-TIME!.... :(  lol
