good day, i need to determine the day of the week. the variable is in text format which i have converted to date. i have used the DayName function to determine the day of the week based on the newly converted date value, but i still get #error.
text to date conversion:
Day of the Week:
anyone that can assist i would appreciate it.