Forum Discussion
How to create this custom weeknumber calculated column.
Hi to all,
I work at a plant where they work in 3 shifts, day, evening and night. I have a column with shiftnames and a date column.
I need to create a custom weeknumber column where the weeks are the following:
The first week is on the first sunday of the year. The week needs to start on sunday, the first sunday of the week need to only contain the night shift data. Then the week needs to end on the next sunday, but that sunday needs to contain the day and evening shift. So the weeks starts at sunday night and end on sunday evening. Does someone know how to do this?
Thanks in advance.
Do it in an external table (for example Excel on SharePoint). Depending on when the night shift starts you may need to introduce a shift (pardon the pun) in the hour value. Like one does for fiscal years.
1 Reply
- lbendlin
Super User
Do it in an external table (for example Excel on SharePoint). Depending on when the night shift starts you may need to introduce a shift (pardon the pun) in the hour value. Like one does for fiscal years.