I am needing to filter by a date in a spreadsheet. I have a list of dates in
a column and I want to only return dates that are = Current Date + 1 day. I
am running a Macro everyday that needs to look out 1 day ahead and return all
dates up to that date.

Thanks,

CR

Have you tried using a Custom filter? You have choices like Less
Than ... , Greater Than ..., and so on.

Hope this helps.

Pete

On Feb 18, 6:19*pm, CR wrote:
I am needing to filter by a date in a spreadsheet. *I have a list of dates in
a column and I want to only return dates that are = Current Date + 1 day. *I
am running a Macro everyday that needs to look out 1 day ahead and return all
dates up to that date.

Thanks,

CR

Yes. Custom Filters do not allow you to do a complex filter such as =Before
Today's Date + (1) Day.

Thanks,

Chad

"Pete_UK" wrote:

Have you tried using a Custom filter? You have choices like Less
Than ... , Greater Than ..., and so on.

Hope this helps.

Pete

On Feb 18, 6:19 pm, CR wrote:
I am needing to filter by a date in a spreadsheet. I have a list of dates in
a column and I want to only return dates that are = Current Date + 1 day. I
am running a Macro everyday that needs to look out 1 day ahead and return all
dates up to that date.

Thanks,

CR

But you could add one to today's date and filter by that -- all in your macro.

CR wrote:

Yes. Custom Filters do not allow you to do a complex filter such as =Before
Today's Date + (1) Day.

Thanks,

Chad

"Pete_UK" wrote:

Have you tried using a Custom filter? You have choices like Less
Than ... , Greater Than ..., and so on.

Hope this helps.

Pete

On Feb 18, 6:19 pm, CR wrote:
I am needing to filter by a date in a spreadsheet. I have a list of dates in
a column and I want to only return dates that are = Current Date + 1 day. I
am running a Macro everyday that needs to look out 1 day ahead and return all
dates up to that date.

Thanks,

CR



--

Dave Peterson