Hi there, and welcome to the forum.
This is actually a perfect place to use a VLOOKUP with an approximate match. (A lot easier to maintain than a really long IF formula.)
Have a look in the attached file. Change your date in the grey cell and the VAT rate in F4 should update for you.