Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spread sheet with the following:
# Name DOB Inauguration date Inauguration age 1 George Washington 2/22/1732 4/30/1789 I input in E2 =D2-C2, expecting to have his age in days - but I get #Value error. I actually want age in a format showing him to be 57 years, 2 months & 8 days (maybe 57y2m8d - or some other compact value). What is my error? Anybody have a good formula for getting me year, month, and day? -- "In no part of the constitution is more wisdom to be found, than in the clause which confides the question of war or peace to the legislature, and not to the executive department." - James Madison |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Determining the nth Column | Excel Programming | |||
Determining if Value In List | Excel Discussion (Misc queries) | |||
Determining End Of data | Excel Programming | |||
Determining the last row in a spreadsheet | Excel Programming | |||
Determining Row Number | Excel Programming |