View Single Post
  #3   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Wed, 10 Nov 2004 15:09:02 -0800, jscano
wrote:

May be a simple question, but how to I calculate the number of days from Jan
1, 2004 to a another specific date?

Thanks.


=A1-B1

or

=A1 - DATE(2004,1,1)

Be sure to format the result as General (or Number).


--ron