Q. I want to extract the DayName from a field or cell but I keep getting #ARG! or #ERROR! as the calculation result. How do I do this?
A. You can do this with a calculation in either the spreadsheet or database environments. Here is the formula for a database:
=DAYNAME(WEEKDAY('Date Field'))
Here is the formula for a Spreadsheet:
=DAYNAME(WEEKDAY(A1))