I created a form titled ‘Daily Timesheet’ for my staff to fill out the activities they have been doing daily. I have laid out the date component at the top, comprising month, day and year. My question is, if I would like to obtain the number of week of a month automatically as per the date they have filled out on the top component, what should I actually do? Is there any specific calculated value, validation or something else that I could input to enable the week number appearing automatically as the month, day and year have been filled out?

​I created a form titled ‘Daily Timesheet’ for my staff to fill out the activities they have been doing daily. I have laid out the date component at the top, comprising month, day and year. My question is, if I would like to obtain the number of week of a month automatically as per the date they have filled out on the top component, what should I actually do? Is there any specific calculated value, validation or something else that I could input to enable the week number appearing automatically as the month, day and year have been filled out?  Read More

​