Filter function using "or" for a date column (blank or >= 01/01/2023)

[Lisa116]

I am not sure how to set up the formula to include blanks or >= 01/01/2023 from the same Term Date column.
I am hopeful that this is a quick fix and that someone will shed some light on it. Currently, the formula looks like this:
FILTER(Activity[[SLSNUM]:[Active]],(Activity[Office Number]=O1)*(Activity[Term Date]>=DATE(2023,1,1))*(Activity[Tier]>=0.25),"")

I need to incorporate the rows where there are blanks in the Term Date.

 

[Fluff]

How about

=FILTER(Activity[[SLSNUM]:[Active]],(Activity[Office Number]=O1)*(Activity[Tier]>=0.25)*((Activity[Term Date]>=DATE(2023,1,1))+(Activity[Term Date]="")),"")

 

[ExceLoki]

try this:

=FILTER(Activity[[SLSNUM]:[Active]],(Activity[Office Number]="O1")*(or(Activity[Term Date]>=DATE(2023,1,1),Activity[Term Date]=""))*(Activity[Tier]>=0.25),"")

 

[Fluff]

You cannot use OR like that in an array

 

[Lisa116]

Fluff,
Thank you so much! I appreciate it. Worked perfect.
Question on the date cells that are blank, is there a way to have the filter populate the blank date cells as blank and not 1/0/1900?

 

[Lisa116]

Thank you too ExceLoki! I appreciate you guys.

 

[Fluff]

Try

=LET(f,FILTER(Activity[[SLSNUM]:[Active]],(Activity[Office Number]=O1)*(Activity[Tier]>=0.25)*((Activity[Term Date]>=DATE(2023,1,1))+(Activity[Term Date]="")),""),IF(f="","",f))

 

[Peter_SSs]

Fluff,
Thank you so much! I appreciate it. Worked perfect.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.