This is a bit of a tricky one, isn't it?

I'd say that you need a macro solution, if that would be acceptable. However, your diary doesn't have a year reference, which is going to complicate matters.

Are you happy to do this with a macro, because I can't see any way that you can do it with standard formula in any sort of manageable way.