Auto-tag the day of the week (Mon–Sun)
how do l implement the "Auto-tag the day of the week
Do you mean converting a timestamp to its weekday equivalent?
Yeah like 4/19/2025 convert to saturday
Use a math column with the formula Weekday(Date)
That will give you a number representing the day of the week, which you can then convert to the day name.
One way to do that is with an if-then-else column, but my preferred method is using a single value column, selecting N from start of a list of names, where N is the weekday number.
Another way is using the Format Date column, but I don’t recommended that as it doesn’t always work reliably.
2 Likes
That’s right. l totally forget that math formula.
Thank you Darren
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.