You seem to have a data issue here. There is no standard to the data in column N so it is really not possible to separate the data either logically or through programming. Can I suggest changing the way you store the information that you store in the notes field of all stores into a minimum and a maximum number of days. It will create a much better data format for future improvements as well. Also if you need help in how to break that data up in a formula let me know.
Bookmarks