You can do a Data-Text to columns and split on the "-" but would probably be
better to use =MONTH(A1) and copy it down, copy paste special values, then
subtotal on this column.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Finn" wrote:

I have a coloumn with dates in the format dd-mm-yyyy
I neet to make a sub total for each change in month
I know it is possible to split the coloumn so I can get the month in a
coloumn of its own, but how do I do it