# Week number in custom field

**URL:** <https://forum.asana.com/t/week-number-in-custom-field/1005044>\
**Category:** Ask the Community\
**Tags:** dates, custom-fields\
**Created:** [19 December 2024 09:28 UTC](https://forum.asana.com/t/week-number-in-custom-field/1005044 "2024-12-19T09:28:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Daniele14](https://luna1.co/8d76cd.png) [@Daniele14](https://forum.asana.com/u/Daniele14)\
**Post date:** [19 December 2024 09:28 UTC](https://forum.asana.com/t/week-number-in-custom-field/1005044/1 "2024-12-19T09:28:30Z")

</div>

Hi all!  
First post as an Asana Ambassador here so please don’t be hard on me 🙂

I’m asking if there’s a way to build a custom field in a project where the date is shown as week number. I’m thinking about the advanced functions, because I can do that with a numerical custom field (just WK1, WK2 ecc.), and using rules to automatize it (like show Jan 05-11 as WK2) but then I’ll have to re-do it every year and that’s not fisible.

Any idea?

---

<div class="post-metadata">

**Author:** ![Zaki\_Imtiaz](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/zaki_imtiaz/32/121780_2.png) [@Zaki\_Imtiaz](https://forum.asana.com/u/Zaki_Imtiaz)\
**Post date:** [24 December 2024 07:16 UTC](https://forum.asana.com/t/week-number-in-custom-field/1005044/2 "2024-12-24T07:16:28Z")

</div>

Hi @Daniele14 ,  
welcome to Asana community. I have worked around your query and come to a solution but for implementing this solution you would need automation tool(i.e zapier/make.com).

Let me tell you step by step;

1. Create a custom number field in your project named **“Week Number”**.
2. Use Zapier or Make to create an integration with Asana using the following logic:

- **Trigger** : When a task is created or a due date is updated in Asana.(You can choose the trigger you want to apply )
- **Action** : Calculate the week number of the year using the task’s due date.
  - Use the `WEEKNUM` function built-in functions in Zapier/Make.
  - Example Logic:
    - Jan 1–7 → W1
    - Jan 8–14 → W2  
As the result of this automation the “Week Number” custom field gets updated in Asana automatically.

Zaki

Business Workflow Consultant

---

<div class="post-metadata">

**Author:** ![Daniele14](https://luna1.co/8d76cd.png) [@Daniele14](https://forum.asana.com/u/Daniele14)\
**Post date:** [27 December 2024 15:52 UTC](https://forum.asana.com/t/week-number-in-custom-field/1005044/3 "2024-12-27T15:52:10Z")

</div>

Hi Zaki! Thank you very much for the solution, I’ll definitly try this one!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/system/32/276370_2.png) [@system](https://forum.asana.com/u/system)\
**Post date:** [3 January 2025 15:52 UTC](https://forum.asana.com/t/week-number-in-custom-field/1005044/4 "2025-01-03T15:52:38Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.