Forum Discussion
Solved
Formula help: How to determine if any dates within series of dates are within 6 months
Hi everyone, I am trying to create a formula to determine if any days that fall within a series of dates are within 6 months of a specific date but only dates that are earlier dates than the date in ...
Let's say the series of dates is in B1:B5 and the specific date is in E1.
=IF(COUNTIFS(B1:B5,">="&EDATE(E1,-6),B1:B5,"<"&E1),"Yes","No")
Let's say the series of dates is in B1:B5 and the specific date is in E1.
=IF(COUNTIFS(B1:B5,">="&EDATE(E1,-6),B1:B5,"<"&E1),"Yes","No")
HansVogelaar Thank you VERY much!
