LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 68
Default Help in determining age

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Determining the nth Column markb Excel Programming 1 July 28th 08 10:26 PM
Determining if Value In List E.Q. Excel Discussion (Misc queries) 2 April 18th 06 06:05 PM
Determining End Of data bnhcomputing[_2_] Excel Programming 2 September 27th 05 11:25 PM
Determining the last row in a spreadsheet Tom Ogilvy Excel Programming 6 September 17th 03 04:59 PM
Determining Row Number Wes Jester Excel Programming 2 August 26th 03 09:20 PM


All times are GMT +1. The time now is 06:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"