Excellent this appears to be working for me! Just one question however, is there a way to remove "Day " and replace with the date suffix instead? E.g 01st; 04th; 11th; 13th instead of Day 1; Day 4; Day 11; Day 13th?

I did notice this from previously

Ordinal Suffix (i.e., "st", "nd", "rd" and "th")
Here is an Excel function that can be used in a cell formula to apply the proper ordinal suffix to the number specified (in cell A1 for this example)...

MID("thstndrdth",MIN(9,2*RIGHT(A1)*(MOD(A1-11,100)>2)+1),2)

More than likely, you will use this function within an Excel formula by concatenating it after the number that is specified with in the function. For example, if cell B1 contains the number, then your formula could be something like this...

="Ordinal for B1: "&B1&MID("thstndrdth",MIN(9,2*RIGHT(B1)*(MOD(B 1-11,100)>2)+1),2)
- just not sure about incorperating it into the previous formula!