Forum Discussion
Weekdays between dynamic range
Thanks for your reply, unfortunately this isn't quite what I'm looking for. Let me try and clarify a little,
I have a data set including the following columns : Begin Date & Calculated End Date during which a specific event was active.
I would like to produce a graph that has Quarters on the axis, for example Q1 2017, Q2 2017 and so on. For each of these quarters I would like the total number of days spent active, summed over every row of my table.
Say for example my data had two rows:
Start Date Calculated End Date
01/01/2018 01/09/2018
01/02/2018 01/09/2018
My graph with quarters on the axis would show the following total Q1: 107 This would be made up of the 65 weekdays within Q1 from row 1 and the 42 weekdays in Q1 from row 2. For Q2 the graph would show 130, made up of the 65 weekdays in Q2 from row 1, and the 65 weekdays in Q2 from row 2.
I hope this is a little clearer, thanks for your help.