Good Morning All,

hopefully a simple one that is just escaping me right now.

I'm looking for a method (in vba) to determine if a passed variable (date) is 3 weeks or multiple of 3 weeks (i.e. 6 weeks, 12 weeks) from a predefined date).

i.e. set date = 05/09/2016, test 26/09/2016 should ring TRUE, as should 07/11/2016 but 31/10/2016 should flag FALSE.

thank you in advance.