BTW,
Jan.1 to Jun.15 is only 5.5 months, isn't it?

One approach might be to calculate 30 day months, where,
A1 = start - 1/1/05
B1 = end - 6/15/05

Format C1 as General or Number, and enter:

=(B1-A1)/30
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"susiespassion" wrote in message
...
When doing a pricing structure, I need to use a date to calculate and then
round into a whole number or decimal , for ex; from 1/1/5 - 6/15/5 how many
months = 6.5 The return is then used to calculate costs involved with
different scenarios for sales and clients.