Formatting Dates

[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

 

[Colin Hayes]

=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")

OK thanks Ron - that's perfect.