Anyone tell me how to insert the corresponding day of week for this date and time code?

[allenmfry1986@gmail.com]

Anyone tell me how to insert the corresponding day of week for this date and time code?


Public Sub StaticTimeStamp()
Selection.InsertDateTime _
DateTimeFormat:="MM/dd/yyyy (hh:mm:ss AM/PM)", InsertAsField:=False


End Sub

[Guessed]

DateTimeFormat:="ddd MM/dd/yyyy" will give you Mon 12/31/2021
DateTimeFormat:="dddd MM/dd/yyyy" will give you Monday 12/31/2021