Hello,
I am trying to get an advance filter to work with the criteria value range in 1 cell.
I have
=">="&WeekStart & "<="&WeekFinish
as the criteria filter range.
It works fine as
=">="&WeekStart
OR
"<="&WeekFinish
but not as a between range.
How do I get the between range to work when specifying it in one cell only?
I am trying to get an advance filter to work with the criteria value range in 1 cell.
I have
=">="&WeekStart & "<="&WeekFinish
as the criteria filter range.
It works fine as
=">="&WeekStart
OR
"<="&WeekFinish
but not as a between range.
How do I get the between range to work when specifying it in one cell only?