Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hi Matt,
Just a slight alteration to your formula that will also eliminate the need for A2. (It may show below as wrapped to several lines. Obviously, you'd enter it all on 1 line.) =DAY(A1)&IF(OR(AND(MOD(DAY(A1),100)=4,MOD(DAY(A1) ,100) <=20),AND(MOD(DAY(A1),100)=24,MOD(DAY(A1),100)<=3 0)),"th", CHOOSE(MOD(DAY(A1),10),"st","nd","rd","th","th","t h","th","th","th"))&" "&TEXT(A1,"mmmm yyyy") Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to merge a date file into an excel format | Excel Discussion (Misc queries) | |||
How do I report a Date Format bug in Excel 2003 to Microsoft ? | Excel Discussion (Misc queries) | |||
Converting a date in Excel 2002 to a Year/Quarter format | Excel Worksheet Functions | |||
Why can't I format cells in Excel 2000? | Excel Discussion (Misc queries) | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions |