Changing Date Format
 

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

Changing Date Format
 

Hi Chris

Take a look at Chip Pearson's site for the production of Ordinals
http://www.cpearson.com/excel/ordinal.htm

I would do this part in a separate cell say C8
then have

="Holiday, Sickness and Training Analysis - "&
TEXT(C7,"DDDD, ")
&C8&(
TEXT(C7," MMMM YYYY"))
--
Regards

Roger Govier


"Chris" wrote in message
...
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

Changing Date Format
 

Thanks for this - works brilliantly!

"Roger Govier" wrote:

Hi Chris

Take a look at Chip Pearson's site for the production of Ordinals
http://www.cpearson.com/excel/ordinal.htm

I would do this part in a separate cell say C8
then have

="Holiday, Sickness and Training Analysis - "&
TEXT(C7,"DDDD, ")
&C8&(
TEXT(C7," MMMM YYYY"))
--
Regards

Roger Govier


"Chris" wrote in message
...
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

Changing Date Format
 

Hi Chris

thanks for the feedback, but all the credit must go to Chip. He figured
out the difficult part.

--
Regards

Roger Govier


"Chris" wrote in message
...
Thanks for this - works brilliantly!

"Roger Govier" wrote:

Hi Chris

Take a look at Chip Pearson's site for the production of Ordinals
http://www.cpearson.com/excel/ordinal.htm

I would do this part in a separate cell say C8
then have

="Holiday, Sickness and Training Analysis - "&
TEXT(C7,"DDDD, ")
&C8&(
TEXT(C7," MMMM YYYY"))
--
Regards

Roger Govier


"Chris" wrote in message
...
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