View Single Post
  #3   Report Post  
Myrna Larson
 
Posts: n/a
Default

Dates ARE stored as numbers, specifically the number of elapsed days since Dec
31, 1899. If you want the difference in months, you can use the undocumented
DATEDIF function: =DATEDIF(A1,B1,"m")


On 5 Oct 2005 12:58:43 -0700, "Teddy" wrote:

Does anyone know how to convert a date into a single number so that you
can do calcuations with it? For example, Nov,2005 minus January, 2004
equals 23.