Formula not adding dates correctly (Excel Web, Windows)

I have a sheet that is referencing another sheet that is populated by a Form.

The 3 columns in particular I have issues with are:

Quantity (B), Received Date (D), and Projected Date (H).

I have a Formula for Projected Date (H) that is supposed to add 3, 5, or 7 work days to the date in Received Date (D) depending on the Quantity(B) number.

=IF(D2="", "", WORKDAY(D2, IF(B2 > 30000, 5, IF(B2 > 150000, 7, 3))))

If there's nothing in D, display Blank, and then to add the appropriate amount of days to the Date in D depending on the Quantity(B).

I've been running tests and am running into oddities with how many days are added to the Received Date (D) when the formula creates the Projected Date (H).

A Job with 2/3/2026 in (D) is showing 2/6/2026 in (H) like it should. Quantity (B) is 16,000

But then the very next line, which also has 2/3/2026 in (D) is showing 2/10/2026 in (H) with a Quantity(B) of 2,000.

Since both are under 30,000 in quantity they should both be showing 2/6/2026, but for some reason, the smaller quantity job is getting 7 days added instead of just 3.