I am trying to add the date into a string of text, but would like the date to
appear in full e.g. Thursday, 25th January 2006 but also use the 'st' or 'rd'
add ons to the end of the date automatically.

The formula i have is as follows:
="Holiday, Sickness and Training Analysis - "&TEXT(C7,"DDDD, D MMMM YYYY")

Can anyone help? Thanks in advance