# WEEKNUM formula?

**URL:** <https://community.parabola.io/t/weeknum-formula/636>\
**Category:** Ask a question\
**Created:** [June 2, 2020, 8:56am UTC](https://community.parabola.io/t/weeknum-formula/636 "2020-06-02T08:56:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matias\_O](https://avatars.discourse-cdn.com/v4/letter/m/dc4da7/32.png) [@Matias\_O](https://community.parabola.io/u/Matias_O)\
**Post date:** [June 2, 2020, 8:56am UTC](https://community.parabola.io/t/weeknum-formula/636/1 "2020-06-02T08:56:26Z")

</div>

Hey guys,

Looking to convert a date into a week number, much like the Excel formula =weeknum().  
How can I do so?

---

<div class="post-metadata">

**Author:** ![sachi](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/sachi/32/10_2.png) [@sachi](https://community.parabola.io/u/sachi)\
**Post date:** [June 2, 2020, 4:16pm UTC](https://community.parabola.io/t/weeknum-formula/636/2 "2020-06-02T16:16:02Z")

</div>

Hi @Matias_O - You can use our [Date Formatter](https://parabola.io/transforms/date-conversion) step for that.

Set your old format by referencing the table in the step documentation linked above.

For your new format, put `WW` (in capital letters) and that’ll convert your date column into “Week of Year (ISO)”.

Let me know how this goes!

---

<div class="post-metadata">

**Author:** ![Matias\_O](https://avatars.discourse-cdn.com/v4/letter/m/dc4da7/32.png) [@Matias\_O](https://community.parabola.io/u/Matias_O)\
**Post date:** [June 4, 2020, 10:45am UTC](https://community.parabola.io/t/weeknum-formula/636/3 "2020-06-04T10:45:51Z")

</div>

That worked, thank you Sachi.
