# \[DONE\] Week number formulas

**URL:** https://community.fibery.io/t/done-week-number-formulas/3880
**Category:** Fibery Showcase
**Tags:** formulas
**Created:** [January 30, 2023, 5:12pm UTC](https://community.fibery.io/t/done-week-number-formulas/3880 "2023-01-30T17:12:25Z")
**Posts on this page:** 1
**Showing post:** 6

<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: [December 10, 2024, 1:45pm UTC](https://community.fibery.io/t/done-week-number-formulas/3880/6 "2024-12-10T13:45:28Z")

</div>

The formulas can now be simplified as follows:

WeekYear:  
`Year(DateField + Days(4 - Weekday(DateField)))`

WeekNum:

```auto
RoundUp(
  ToDays(
    DateField - (Date(WeekYear, 1, 1) + Days(3 - Weekday(Date(WeekYear, 1, 4))))
  ) / 7,
  0
)

```

---

_[View the full topic](https://community.fibery.io/t/done-week-number-formulas/3880)._