Months set to a value of 1

[Dan C]

Is it possible to calculate number of months in a formula,
such as "Sep03 to Dec03 would be 3 months"? I currently
break it down using days, but the varying days in a month
is a problem.

Thanks, Dan

 

[Dan E]

Dan,

Have a look at the datedif function, detailed on chip pearson's
site.
http://www.cpearson.com/excel/datedif.htm

Dan E

 

[Peo Sjoblom]

See:

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

 

[Chip Pearson]

Dan,

You can use the DATEDIF function to do this. See
www.cpearson.com/excel/datedif.htm for more details.

 

[Guest]

Chip,

I checked out your website on the DATEIF. It works well,
except for February. Is there a way of making Feb. work?