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