Help with a macro please

[Buns1976]

Hi Everyone,

I need to run a macro that would insert the DAY in C2 based on the DATE in B2 so if B2 is 4/10/19, then C2 would be Wednesday.

Thank You!

 

[mumps]

Try:

Sub test()
    Range("C2") = WorksheetFunction.Text(Range("B2"), "dddd")
End Sub

 

[Buns1976]

Thank you Mumps! That did the trick!!

Have a great day!!

 

[mumps]

Thank you and you are very welcome.