So the problem for this is to separate all the date and keep like the month and day, the real problem is when the consecutive days are between last days of the month and first of the next one.
Its pretty hard xD
Edited: for the first part (separate) i could use:
left(text, count)
Return the first count characters of text.
right(text, count)
Return the last count characters of text.