Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for changing date format | Excel Worksheet Functions | |||
Changing to date format | Excel Discussion (Misc queries) | |||
Changing date format in a footer | Excel Discussion (Misc queries) | |||
Seemingly changing date format? | Excel Discussion (Misc queries) | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions |