Best logic to return TRUE in VBA if month NAMES are 1 apart?

[dmasters4919]

I want to return TRUE for the following examples:


Example 1
Date 1: 7/31/14 Date 2: 8/1/14


Example 2
Date 1: 12/31/07 Date 2: 1/1/16 (notice one year is 2007)

and FALSE for the following example

Example 1:
Date 1: 7/31/14 Date 2: 9/1/14


What is the smartest way to go about this? I know I can use the Month() function and test whether the months are either different by 1 or 11, but that seams like a bad solution

[JasperD]

Why would that be a bad solution?

Please Login or Register  to view this content.

[6StringJazzer]

What is the smartest way to go about this? I know I can use the Month() function and test whether the months are either different by 1 or 11, but that seams like a bad solution

That is the smartest way to go about it and it is a good solution.
JasperD is on the right track but did not include the Dec/Jan case. Also if x=0 the months are the same, not 1 apart, so I think that case is False.

Please Login or Register  to view this content.