Excel Help

Post Reply
User avatar
OscarGuy
Site Admin
Posts: 13668
Joined: Wed Jan 01, 2003 12:22 am
Location: Springfield, MO
Contact:

Post by OscarGuy »

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
User avatar
OscarGuy
Site Admin
Posts: 13668
Joined: Wed Jan 01, 2003 12:22 am
Location: Springfield, MO
Contact:

Post by OscarGuy »

Thanks. Already found this site and the DATEDIF function doesn't exist.
Wesley Lovell
"Any society that would give up a little liberty to gain a little security will deserve neither and lose both." - Benjamin Franklin
User avatar
MovieWes
Professor
Posts: 2019
Joined: Wed Jan 01, 2003 12:33 pm
Location: San Antonio, Texas, USA
Contact:

Post by MovieWes »

Calculate Age in Excel



Edited By MovieWes on 1230655631
"Young men make wars and the virtues of war are the virtues of young men: courage and hope for the future. Then old men make the peace, and the vices of peace are the vices of old men: mistrust and caution." -- Alec Guinness (Lawrence of Arabia)
User avatar
OscarGuy
Site Admin
Posts: 13668
Joined: Wed Jan 01, 2003 12:22 am
Location: Springfield, MO
Contact:

Post by OscarGuy »

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.
Wesley Lovell
"Any society that would give up a little liberty to gain a little security will deserve neither and lose both." - Benjamin Franklin
Post Reply

Return to “General Off-Topic”