Function to retrurn true if at least one day between two dates is within desired month

[shimaparty]

Hi all,

I need to come up with a function that would return TRUE if between start date and end date, there is at least one February day :

e.g. Start date 01/01/2016 , End date 01/03/2016 -----> TRUE
Start date 01/01/2016 , End date 31/01/2016 -----> False


Thank you

[FDibbins]

Try this...

	A	B
1	1-Jan-16	1-Jan-16
2	1-Mar-16	31-Jan-16
3	TRUE	FALSE

A3=AND(2>=MONTH(A1),2<=MONTH(A2))
copied across

[FDibbins]

After testing with a friend at work I saw that my formula above will only work within the same year. As soon as you span years, i *can* fail.

Try this instead....

	A	B	C
1	01/01/2016	01/01/2016	03/12/2015
2	03/01/2016	01/31/2016	05/05/2020
3	TRUE	FALSE	TRUE

A3=AND(DATE(IF(AND(A1>DATE(YEAR(A1),2,1),A2>=DATE(YEAR(A2),2,28)),YEAR(A2),YEAR(A1)),2,1)>=A1,DATE(IF(AND(A1>DATE(YEAR(A1),2,1),A2>=DATE(YEAR(A2),2,28)),YEAR(A2),YEAR(A1)),2,28)<=A2)
copied across

[cbatrody]

OR,

Try the following in C1:

=IF(OR(OR(MONTH(A2)=2,MONTH(B2)=2),AND(MONTH(A2)<=1,MONTH(B2)>=2),AND(YEAR(B2)>YEAR(A2),MONTH(B2)>=2)),"TRUE","FALSE")

See the attached file.