Excel Help
- OscarGuy
- Site Admin
- Posts: 13668
- Joined: Wed Jan 01, 2003 12:22 am
- Location: Springfield, MO
- Contact:
Complex as all hell, but I finally came up with a formula (or several spread across several columns) to figure what I wanted to do including leap years...Now, just to figure out how to implement it all to get the exact information I want...
Wesley Lovell
"Any society that would give up a little liberty to gain a little security will deserve neither and lose both." - Benjamin Franklin
"Any society that would give up a little liberty to gain a little security will deserve neither and lose both." - Benjamin Franklin
- OscarGuy
- Site Admin
- Posts: 13668
- Joined: Wed Jan 01, 2003 12:22 am
- Location: Springfield, MO
- Contact:
I'm not the most expert Excel user there is, I know how to do a good deal, but some things frustrate me.
Does anyone know a way, with a formula or function, a way for one cell to calculate the number of years and days a person has been alive to a certain point? If there weren't leap years, I'd have no problem calculating it myself, but as it stands, I'm having a hard time figure out how exactly to do it.
Does anyone know a way, with a formula or function, a way for one cell to calculate the number of years and days a person has been alive to a certain point? If there weren't leap years, I'd have no problem calculating it myself, but as it stands, I'm having a hard time figure out how exactly to do it.
Wesley Lovell
"Any society that would give up a little liberty to gain a little security will deserve neither and lose both." - Benjamin Franklin
"Any society that would give up a little liberty to gain a little security will deserve neither and lose both." - Benjamin Franklin