# Creating a 'Current Week Calendar' Event Board with WeekDays as columns

**URL:** <https://community.fibery.io/t/creating-a-current-week-calendar-event-board-with-weekdays-as-columns/5763>\
**Category:** Get Help\
**Created:** [January 27, 2024, 10:49am UTC](https://community.fibery.io/t/creating-a-current-week-calendar-event-board-with-weekdays-as-columns/5763 "2024-01-27T10:49:48Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [January 27, 2024, 2:19pm UTC](https://community.fibery.io/t/creating-a-current-week-calendar-event-board-with-weekdays-as-columns/5763/3 "2024-01-27T14:19:03Z")

</div>

Create a db with the 7 days of the week, and a formula as follows:

```auto
Today() -
  Days(
    If(WeekDayName(Today()) = "Monday", 0,
      If(WeekDayName(Today()) = "Tuesday", 1,
        If(WeekDayName(Today()) = "Wednesday", 2,
          If(WeekDayName(Today()) = "Thursday", 3,
            If(WeekDayName(Today()) = "Friday", 4,
              If(WeekDayName(Today()) = "Saturday", 5, 6)
            )
          )
        )
      )
    )
  ) +
  Days(
    If(Name = "Monday", 0,
      If(Name = "Tuesday", 1,
        If(Name = "Wednesday", 2,
          If(Name = "Thursday", 3,
            If(Name = "Friday", 4,
              If(Name = "Saturday", 5, 6))
          )
        )
      )
    )
  )

```

Make sure to save it as the Date data type (not Date time).

![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/f/f7e055e95ed55ad90c0eb2cecfa8c909e7629670.png)

Now you can create an auto-relation to your Event db, with the matching rule using the Date field in the Event db and the Date field in the Day this Week database:

![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/2b2cd07b989e65c8f3ef765c45471bb2fe707f56.png)

No automations necessary 🙂

---

_[View the full topic](https://community.fibery.io/t/creating-a-current-week-calendar-event-board-with-weekdays-as-columns/5763)._