is date three weeks (or multiple of three weeks) from a set date.

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.

D'oh that is incredibly simple.

thank you for the help. you wouldn't believe the complicated mumbo jumbo voodoo i've been trying.

Already factored time out as I was aware that'd throw a spanner in the works.

one thing I did manage before going off the range a little.