Calculate Week number from multiple choice dates column
We are running a Wellness challenge for a charity. Participants log the days and duration when they performed the activity.
We allow selecting multiple dates for the same activity.
I try to total Duration for a week. "Duration" mean the number of hours for each of the selected days.
First, I need to convert a date into a Week. How can I do it considering that dates are in a multi-select column?
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!