View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Howard Brazee Howard Brazee is offline
external usenet poster
 
Posts: 68
Default Help in determining age

On Thu, 22 Jan 2009 10:59:16 -0700, Howard Brazee
wrote:

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 see one problem - all of the dates older than 1900 in this spread
sheet are left justified, all of the newer ones are right justified.
It appears that I need to do something special to handle older dates.

Only when both dates are greater than 1900 do I get a subtraction of
dates.

I just don't know the solution.

--
"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