ExcelBanter - View Single Post

wendy

'Fred Smith[_4_ Wrote:
;3455255']How about:
=datedif(a1,a2,"m")+(a2=eomonth(a2,0))

Regards,
Fred

"wendy" wrote in message
...-

I have looked through some older posts and thought I had found the
answer to my problem I'm nearly there but not quite!

The start date identifies the start month. It doesn't matter what
date
in the month it is. The end date month only counts if the end date is
the last day of the month i.e. 10 May to 29 June would only count as
1
month for May. 10 May to 30 June would count as 2 months because it
includes the last day of the month.

can anyone help I am using datedif to work out the months but I only
want it to count the end date month if it is the last day of the
month.
The list contains various end dates like the example above. Thanks
in
advance for any help on this x

--
wendy -
thankyou for your help x

--
wendy