date

[terre]

Is there a way to format dates as

11th September 2001
21st July 2012

etc?

 

[MajP]

http://dmcritchie.mvps.org/excel/datetime.htm#ordinal

see function orddate

 

[terre]

Wow...easy as

Thank you

 

[strongm]

Might be more interesting to have this based on a more general purpuse oridnal function which could have uses elsewhere - something like

[blue]Public Function OrdDate(dtDate As Date) As String
    OrdDate = Ordinal(Day(dtDate)) & " " & Format(dtDate, "mmmm") & " " & Year(dtDate)
End Function

Public Function Ordinal(lNumber As Long) As String
    Dim suffix As String
    
    suffix = "th"
    If CLng(lNumber \ 10) Mod 10 <> 1 Then
        Select Case lNumber Mod 10
            Case 1: suffix = "st"
            Case 2: suffix = "nd"
            Case 3: suffix = "rd"
        End Select
    End If
    Ordinal = lNumber & suffix
End Function[/blue]