Hi:

I have two dates:

2/3/2005

6/8/2007

I need to calculate the number of months PER YEAR between the dates.
For example:

YEAR # MONTHS/YR
2005 12
2006 12
2007 6

This can be VBA, a recorded macro, or a calc. Thanks!

On Jul 11, 5:34*pm, amywolfie <amywol...@gmail.com> wrote:
> Hi:
>
> I have two dates:
>
> 2/3/2005
>
> 6/8/2007
>
> I need to calculate the number of months PER YEAR between the dates.
> For example:
>
> YEAR * *# MONTHS/YR
> 2005 * * 12
> 2006 * * 12
> 2007 * * *6
>
> This can be VBA, a recorded macro, or a calc. *Thanks!

This UDF (placed in a REGULAR module) and then, on the sheet, type
=monthsinyear(a1,a2,2005)
or if b1 has 2005
=monthsinyear(a1,a2,b1)
to get 2005

Thanks Don.

I have never written VBA code for Excel, only Access.

How do you define a REGULAR module?

Do you create a Public Function monthsinyear () where

Dim monthsinyear As Integer

Is there anything else that has to be coded in VBA?

Thanks!
====