View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
hellZg8
 
Posts: n/a
Default how long date difference

hello Marcelo and Ciao
thank you both for you quick response

both formulas return a value in c2

example

a1= Feburary 18,1988
b1=Now()
c2=19.4 years

cells a1 & b1 are both formated with date as shown in a1 example
(mmmm dd,yyyy)