I am using a variable to hold the day of the week for a given day
Dim DayOfWeek As Date
DayOfWeek = ThisWorkbook.Sheets("Menu").Range("D2").Value
If the value of this cell is a date, how can I have the variable hold
the name of the day of the week? I want to use this to add the day
name to a filename ie Monday Report.xls.