Dia de la seman

There are a few different ways to do it.

  • At the basic level, a math column with the formula WEEKDAY(Date) will return a number. 1=Sunday and 7=Saturday. Once you have that number you can use an IF column to return the proper day name.
  • Another option is to use the Format Date column to convert a date into a day of the week, but it can be buggy and not work on certain devices or in certain regions.
  • A third option if you need to do this often is to follow the directions in this post.
    It can be overkill if you only need to do it once, but if you need it often it can save you from having to configure the same IF column over and over. Chart of averages - #6 by Darren_Murphy
2 Likes