Formatting Dates

C

Colin Hayes

Hi All


With a date in A1, this formula in D4 gives Saturday, October 30th :


=TEXT(A1,"dddd, mmmm
d")&MID("stndrdthstndrdthst",MATCH(DAY(A1),{1,2,3,4,21,22,23,24,31},1)*2-1,2)



I'm trying to have the formula return Saturday, October 30th 2010.


Can anyone advise how to amend it to do this?

Thanks

Best Wishes
 
R

Ron Rosenfeld

Hi All


With a date in A1, this formula in D4 gives Saturday, October 30th :


=TEXT(A1,"dddd, mmmm
d")&MID("stndrdthstndrdthst",MATCH(DAY(A1),{1,2,3,4,21,22,23,24,31},1)*2-1,2)



I'm trying to have the formula return Saturday, October 30th 2010.


Can anyone advise how to amend it to do this?

Thanks

Best Wishes
Click to expand...


=TEXT(A1,"dddd, mmmm
d")&MID("stndrdthstndrdthst",MATCH(DAY(A1),{1,2,3,4,21,22,23,24,31},1)*2-1,2)&
TEXT(A1," yyyy")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WEEKDAY 7
Date/Time 1
Exclude weekends when counting days only on day 29 or 30 3
Day formula 4
Start Day of Bi-Monthly Pay Period 8
Showing Day and Date in the same Cell 4
How to change the date format? 2
if statements returning dates 4

Top