Filtering by a date
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 |
Filtering by a date
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 |
Filtering by a date
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 |
Filtering by a date
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 |
All times are GMT +1. The time now is 05:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com