"Rick Rothstein \(MVP - VB\)" wrote...
....
Why, by the way, did you opt to use the 2nd argument in the WEEKDAY
function call instead of the simpler single-argument form of this
function?

Because the OP has a UK e-mail address, and I'm not sure anyone
outside the US thinks of Sunday as the 1st day of the week. That is, I
was guessing the OP would find it more obvious to think of Thursday as
the 4th day of the week.