# Autogenerate Week number from selected Date in xlsForm collect

**URL:** <https://forum.getodk.org/t/autogenerate-week-number-from-selected-date-in-xlsform-collect/39766>\
**Category:** Support\
**Created:** [December 4, 2022, 5:29pm UTC](https://forum.getodk.org/t/autogenerate-week-number-from-selected-date-in-xlsform-collect/39766 "2022-12-04T17:29:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![GBU\_Tuco](https://getodk.b-cdn.net/letter_avatar_proxy/v4/letter/g/d26b3c/32.png) [@GBU\_Tuco](https://forum.getodk.org/u/GBU_Tuco)\
**Post date:** [December 4, 2022, 5:29pm UTC](https://forum.getodk.org/t/autogenerate-week-number-from-selected-date-in-xlsform-collect/39766/1 "2022-12-04T17:29:57Z")

</div>

**1. What is the issue?**  
I am trying to use the selected date to autogenerate the week number from the date selected. I am using xlsForm, Kindly help

---

<div class="post-metadata">

**Author:** ![danbjoseph](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/danbjoseph/32/21901_2.png) [@danbjoseph](https://forum.getodk.org/u/danbjoseph)\
**Post date:** [December 5, 2022, 1:18pm UTC](https://forum.getodk.org/t/autogenerate-week-number-from-selected-date-in-xlsform-collect/39766/2 "2022-12-05T13:18:27Z")

</div>

Please see if this thread solves your problem:

> [@Auto generate week number from date](https://forum.getodk.org/t/auto-generate-week-number-from-date/17633):
>
> What is the problem? Please be detailed. Please can you help me get a week number automatically when I select date in a survey?I have an XLSForm which I use to collect survey data. I have date, so when the user select the date, the year is autoclaved and displayed as "18, 0r 19" meaning 2018 or 2019 depending on the date selected. the month is also auto generated from the selected date. I want to Auto generate week number from selected date in an xlsForm to be used in ODK? e.g. when I select 5th…