|Were you looking for today's date? if so previous reply has it.|
If you were looking for the number of the day of the date such as 15 for august 15th 1964, then you would use the DAY(A1) to get the number assuming that cell A1 contains the date in a valid date format.
if you were looking for the day of the week for june 3rd 2020, then you can use:
numbers 1 to 7 will be returned with 1 being sunday and 7 being saturday
combine this with a choose statement and you can get it to return The day of the week as a text value.
Just discovered this and much simpler