rounding the DATEDIF function

Is there a way I can round the DATEDIF function so that partial months are counted as a whole month.

For example here is what i want my spreadsheet to say;

start date end date total months
6/25/05 7/31/05 2


right now my function makes total months equal to 1. Thanks for any suggestions.

This seems to work for your example, if you format the cell as general.

=MONTH(B1)-MONTH(A1)+1

--
tj


"speary" wrote:

>
> Is there a way I can round the DATEDIF function so that partial months
> are counted as a whole month.
>
> For example here is what i want my spreadsheet to say;
>
> start date end date total months
> 6/25/05 7/31/05 2
>
>
> right now my function makes total months equal to 1. Thanks for any
> suggestions.
>
>
> --
> speary
> ------------------------------------------------------------------------
> speary's Profile: http://www.excelforum.com/member.php...o&userid=24959
> View this thread: http://www.excelforum.com/showthread...hreadid=388479
>
>

forgot to add:
=ABS(MONTH(B1)-MONTH(A1))+1
For your example, this will compensate, if the dates are flipped.

--
tj


"speary" wrote:

>
> Is there a way I can round the DATEDIF function so that partial months
> are counted as a whole month.
>
> For example here is what i want my spreadsheet to say;
>
> start date end date total months
> 6/25/05 7/31/05 2
>
>
> right now my function makes total months equal to 1. Thanks for any
> suggestions.
>
>
> --
> speary
> ------------------------------------------------------------------------
> speary's Profile: http://www.excelforum.com/member.php...o&userid=24959
> View this thread: http://www.excelforum.com/showthread...hreadid=388479
>
>

=datedif(startdate,enddate,"m")+1
would that work for you?

"speary" <speary.1sfnih_1121803543.0165@excelforum-nospam.com> wrote in
message news:speary.1sfnih_1121803543.0165@excelforum-nospam.com...
>
> Is there a way I can round the DATEDIF function so that partial months
> are counted as a whole month.
>
> For example here is what i want my spreadsheet to say;
>
> start date end date total months
> 6/25/05 7/31/05 2
>
>
> right now my function makes total months equal to 1. Thanks for any
> suggestions.
>
>
> --
> speary
> ------------------------------------------------------------------------
> speary's Profile:
> http://www.excelforum.com/member.php...o&userid=24959
> View this thread: http://www.excelforum.com/showthread...hreadid=388479
>