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