Forum Discussion
Dynamic Count of Week between two dimensions
Hi DataFab2023 ,
What is your logic for counting how many weeks there are between two dates? Do you get the difference between the two and divide it by seven? Also, and as always, please post a sample data that we can copy-paste (not an image).
hi DataFab2023 ,
I understand that the week count is to be calculated for each even but which columns are used for calculations? Is just OpenDate vs SalesDate in the same row or need to access the previous SalesDate? Once the number of days has been calculated, how do you then translate that to a week count?
OpenDate is always the start point so the week should start counting from OpenDate
Calculating the number of days between two dates is fairly easy but you still did not mention how to calculate for the week. For example, there are 56 days from 1/1 to 25/2 which translates to roughly 8 weeks (56 days/7 days in a week) but your sample result shows 5.