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

Picking up on that theme, one could use the DAYS360 function and divide by 30
for a standardized way of handling the variation in month lengths.

On Fri, 4 Feb 2005 16:51:55 -0800, "RagDyer" wrote:

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