• Be aware that this only works if DATEFIRST is 7. You'll need to adjust the calculation accordingly.