Hi and welcome to the forum

Hard to be specific without seeing a sample of what you are working with, mut maybe something like this?

=if(or(cell-ref<=datestart,cell-ref>dateend),"",your-formula)