Hello,
I'm wondering if it's possible to create macro with a date function that would get a range of rows as specified by a date range. For example, I have an Excel file that has a column of dates in the format of x/xx/xxxx; now let's suppose today's date is 2/25/2023 and I'd like to get all the data (rows) between last week Friday (2/17/2023) and this past Thursday (2/23/2023). Basically I'm looking for a function that will parse the date column and always find last week Thursday data (rows) to this week Friday for any given week. Appreciate any pointers and/or assitance with this
Thanks
I'm wondering if it's possible to create macro with a date function that would get a range of rows as specified by a date range. For example, I have an Excel file that has a column of dates in the format of x/xx/xxxx; now let's suppose today's date is 2/25/2023 and I'd like to get all the data (rows) between last week Friday (2/17/2023) and this past Thursday (2/23/2023). Basically I'm looking for a function that will parse the date column and always find last week Thursday data (rows) to this week Friday for any given week. Appreciate any pointers and/or assitance with this
Thanks