When you use WEEKDAY function in Excel, you enter a date like 1.1.2020 and maybe hope to see the weekday. However, WEEKDAY returns you a number. With Return_type argument, you can define the number, but number is still a number. It would be nice to have a weekday like Monday or Tuesday instead of the number.

I have seen some ways to have a weekday instead of number.

I like an IF-sentence.

=IF(WEEKDAY(A4)=1;”Sunday”;IF(WEEKDAY(A4)=2;”Monday”;IF(WEEKDAY(A4)=3;”Tuesday”;IF(WEEKDAY(A4)=4;”Wednesday”;IF(WEEKDAY(A4)=5;”Thursday”;IF(WEEKDAY(A4)=6;”Friday”;IF(WEEKDAY(A4)=7;”Saturday”)))))))

It is a bit long, but once I wrote it, you can just copy paste it.

Just paste the text to cell B4.

Another option is that you create your own function with the same logic.

Function z_wd(z_d As Date)

If WorksheetFunction.Weekday(z_d) = 1 Then

    z_wd = “Sunday”

ElseIf WorksheetFunction.Weekday(z_d) = 2 Then

    z_wd = “Monday”

ElseIf WorksheetFunction.Weekday(z_d) = 3 Then

    z_wd = “Tuesday”

ElseIf WorksheetFunction.Weekday(z_d) = 4 Then

    z_wd = “Wednesday”

ElseIf WorksheetFunction.Weekday(z_d) = 5 Then

    z_wd = “Thursday”

ElseIf WorksheetFunction.Weekday(z_d) = 6 Then

    z_wd = “Friday”

ElseIf WorksheetFunction.Weekday(z_d) = 7 Then

    z_wd = “Saturday”

End If

End Function

To use the function in B2 might be easier than direct IF-sentence.