Jun 02 2020 04:29 AM
Hi everyone,
I want to do a year on year analysis and only include accounts which:
If Date Closed (column A) OR Date Deferred (column B) is between Start Date and End Date in 2019 OR 2020, then column C must say "INCLUDE"
Please see excel attached, hugely appreciate your response in advance!
Thanks
Jenny
Jun 02 2020 05:03 AM - edited Jun 02 2020 05:04 AM
Solution@JennySommet
Try if this works for you
=IF(OR(AND(A2>=$F$2,A2<=$F$3),AND(A2>=$G$2,A2<=$G$3),AND(B2>=$F$2,B2<=$F$3),AND(B2>=$G$2,B2<=$G$3)),"INCLUDE","")
I have included both the start and end dates in the formula
Jun 02 2020 06:13 AM
Jun 02 2020 09:56 AM
Jun 03 2020 05:18 AM
Jun 04 2020 04:15 AM
Glad to help
Jun 02 2020 05:03 AM - edited Jun 02 2020 05:04 AM
Solution@JennySommet
Try if this works for you
=IF(OR(AND(A2>=$F$2,A2<=$F$3),AND(A2>=$G$2,A2<=$G$3),AND(B2>=$F$2,B2<=$F$3),AND(B2>=$G$2,B2<=$G$3)),"INCLUDE","")
I have included both the start and end dates in the formula