I'm guessing that you are counting months between two dates, right?

Take a look at Chip Pearson's site about dates and date calculations:

http://www.cpearson.com/excel/datedif.htm


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