Excel Issue between dates (specific month)

[richard1234567891011]

Hi Guys,

I have an issue with a formula. I need an if between dates with in the middle August. Example: 12/06/2019 12/10/2019
If in the range there is august do something, otherwise something else.

I have no idea how to write it.

Thank you guys,

Have a nice weekend.

 

[Joe4]

Assuming that your dates are in cells A1 and A2, and A2 is always after A1, this formula will return a "Yes" if any August date falls in the range, and a "No" if it does not.

=IF(AND(DATE(YEAR(A1),8,31)>=A1,DATE(YEAR(A1),8,1)<=A2),"Yes","No")