W
wendy
I have looked through some older posts and thought I had found th
answer to my problem I'm nearly there but not quite!
The start date identifies the start month. It doesn’t matter what dat
in the month it is. The end date month only counts if the end date i
the last day of the month i.e. 10 May to 29 June would only count as
month for May. 10 May to 30 June would count as 2 months because i
includes the last day of the month.
can anyone help I am using datedif to work out the months but I onl
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 i
advance for any help on this
answer to my problem I'm nearly there but not quite!
The start date identifies the start month. It doesn’t matter what dat
in the month it is. The end date month only counts if the end date i
the last day of the month i.e. 10 May to 29 June would only count as
month for May. 10 May to 30 June would count as 2 months because i
includes the last day of the month.
can anyone help I am using datedif to work out the months but I onl
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 i
advance for any help on this