A
acw
Roy
One way is to use the YEARFRAC function. This can then be
multiplied by 12 to get the number of months. You can put
in different options to work out the number of days in the
month, days in year (30/360 etc).
Alternatively you can do the same sort of thing by
subtracting the 2 dates, divide by 365 and then mulitply
by 12. Again it will provide the number of months which
can be rounded to suit (there can be 7 or 8 months between
February and September depending on whether you count the
first month or not).
Tony
One way is to use the YEARFRAC function. This can then be
multiplied by 12 to get the number of months. You can put
in different options to work out the number of days in the
month, days in year (30/360 etc).
Alternatively you can do the same sort of thing by
subtracting the 2 dates, divide by 365 and then mulitply
by 12. Again it will provide the number of months which
can be rounded to suit (there can be 7 or 8 months between
February and September depending on whether you count the
first month or not).
Tony