I am coming up with very different numbers ot your grid, so want to make sure are counting the same thing.

You want open jobs for the period? So if a job was started in May 2020 and closed in september 2020 what job would count in May, June, July, August and September?

I make Franks count for the 31th of May 2020 to the 30th of June 2020 as 24 jobs open

Hi Purfleet, thanks for your help. The numbers in the table are fictional just to give an impression of what I’m trying to produce. The results I was getting were so far off the mark I had to give up and enter made-up numbers.