Forum Discussion
Using a combination of IF Statement and LET function
Hello, I am trying to do the following from the attached link: If the Fiscal period date in Col B (of the SORTED_INV_CN worksheet) is greater than/equal to Dec 2025 or less than April 2025 then ty...
Do you mean date range to ignore or just those two dates? To ignore two date range try-
=IF(AND(A2>=$G$3,A2<=$G$2),"Ignore",LET(x,"Your formula here",x))To ignore only those two date, try-
=IF(OR(A2=$G$2,A2=$G$3),"Ignore",LET(x,"Your formula here",x))