Count Unique values if they fall between a date range

I am a novice user and can't figure out the formula to my problem. I want a fomula to return a count based on if the entry falls between two dates. The caveat is I only want the count of unique "Job ID". I have attached an example. There are a total of 30 entries on Sheet 2 but only 25 of them have unique "Job ID". I figured out the fomula to count between the date ranges.

=COUNTIFS(Sheet2!$D$2:$D$31,">="&$A2,Sheet2!$D$2:$D$31,"<="&$B2)

I also figured out the formula for counting the unique entries.

=SUM(IF(FREQUENCY(Sheet2!A2:A31,Sheet2!A2:A31)>0,1))

Just not sure how to put them together so the work. Any help would be appreciated.

Thanks.

A pivot table will not work for what I am trying to do.

The data I attached is sample data. It is all part of a bigger yearly team tracker which I use and I don't want to change the format of my tracker. Thank you for your suggestion and yes, I did look at your file, just not interested in using a pivot table.