Skip to Content
0
Jan 31, 2021 at 10:07 AM

day of the week

26 Views

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:

=FormatDate(ToDate([PostingDate];"yyyyMMdd");"yyyy/MM/dd")

Day of the Week:

=DayName(ToDate([newdate];"ddd"))

anyone that can assist i would appreciate it.