Forum Discussion
Blake753
Helper II
Helper IIGroup Dates into 2 week intervals
I have a set of data with dates starting on 1/5/2020. I need to group these dates in a column into 2 week intervals with the last Saturday date being the return value. These dates always begin on a Sunday and end on a Saturday. For example:
1/5/2020 would return 1/18/2020
1/17/202 would return 1/18/2020
1/19/2020 would return 2/1/2020
and so on
Blake753 , Try like
Week end date = date(2020,1,5) + (Quotient(datediff(date(2020,1,5),[Date],day),14)+1)*14
4 Replies
- amitchandak
Super User
Blake753 , You can divide into week like this
2 Week No = Quotient(datediff(date(2020,1,5),[Date],day),14)+1
Week end date = date(2020,1,5) + (Quotient(datediff(date(2020,1,5),[Date],day),14)+2)*7
Blake753- amitchandak
Blake753 , Try like
Week end date = date(2020,1,5) + (Quotient(datediff(date(2020,1,5),[Date],day),14)+1)*14