如何在VBA语句中使用WEEKNUM函数？

I want to write a VBA, to check if WEEKNUM or ISOWEEKNUM equal to the value, then run the rest of macro. I've tried to do that but I got an error because of using TODAY as arg.I want to write a VBA, to check if WEEKNUM or I