Find if Excel is using US or UK date format

[WaqasTariq]

Hi,
Is there anything in Excel VBA that will identify the current date format of Excel?

I am writing a macro and the people who will use it will be in the US and UK. I do not want to create two different solutions. Is there a way I can know what date format Excel is using so that I can base my rest of the code on that information?

 

[Siddharth Rout]

You can use the Application.International property (Excel) with xlDateOrder

For example

Option Explicit

Sub Sample()
    Dim DateOrderType As Integer
    
    DateOrderType = Application.International(xlDateOrder)
    
    Select Case DateOrderType
        Case 0: Debug.Print "M-D-Y"
        Case 1: Debug.Print "D-M-Y"
        Case 2: Debug.Print "Y-M-D"
    End Select
End Sub

 

[WaqasTariq]

You can use the Application.International property (Excel) with xlDateOrder

For example

Option Explicit

Sub Sample()
    Dim DateOrderType As Integer
   
    DateOrderType = Application.International(xlDateOrder)
   
    Select Case DateOrderType
        Case 0: Debug.Print "M-D-Y"
        Case 1: Debug.Print "D-M-Y"
        Case 2: Debug.Print "Y-M-D"
    End Select
End Sub

Thank you, that worked perfectly!