looking for an efficient way to calculate the number of weeks

James_rayan

Is there a more efficient way to calculate the number of weeks between a start date and an end date without using intermediary steps or an extra column? Currently, I use a formula to find the difference in days between the two dates and then divide by 7 to get the number of weeks. I'm wondering if there's a more direct formula that can compute the weeks between the start and end dates without needing any additional calculations.

Zachary Ziegler

You can auto-calculate event durations, but they only show up in days currently and like you said you'd have to divide by 7 to find the weeks and round up if you want an integer. This might be a nice feature request to submit though as I can see why it would make a good quality of life update!