I can make any claim I like, and the OP signed off on it, so I am happy to
leave it at that,
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
That is most odd because I get
TRUE TRUE FALSE FALSE
with both, not what the OP suggested, but more logically sound methinks.
Without knowing the OP's purpose, I don't see how you can make that
claim. I don't see how your result is any more "logically sound" than
what the OP asked for. Frankly, I am suspicious of the OP's motives.
I suspect she doesn't want either result.
Be that as it may, I think the following straight-forward formula,
albeit a mouthful, provides exactly the result that the OP is looking
for, for whatever reason, where B1 and B2 are the start and end dates:
=OR( AND(2=MONTH(DATE(YEAR(B1),2,29)),
B1<=DATE(YEAR(B1),2,29),
DATE(YEAR(B1),2,29)<=B2),
AND(2=MONTH(DATE(YEAR(B2),2,29)),
B1<=DATE(YEAR(B2),2,29),
DATE(YEAR(B2),2,29)<=B2) )
And I'm surprised that Bob did not offer the following alternative:
=(SUMPRODUCT(--(2=MONTH(DATE(YEAR(B1:B2),2,29))),
--(B1<=DATE(YEAR(B1:B2),2,29)),
--(DATE(YEAR(B1:B2),2,29)<=B2)) > 0)
Both approaches rely on the OP's assurances that the start and end
dates are within 366 days of each other.
Note to the OP: If you are trying to decide whether to use 365 or 366
as a factor in some computation (e.g. daily interest rate), I don't
believe your simple criterion is sufficient. And if you have some
other reason for trying to decide between 365 and 366, I suggest that
you post your purpose. There might be more tractable ways of
achieving your purpose.
----- original posting -----
