Filter the start by two weeks starting the current date

M

Majid

Hello Dear,
Would you please advise whether we can customize a column such as "start
column" to filter for two weeks period. However, the customized filter to be
able to pick up today's date as the start date automatically rather than I
select today's date each time.
Please advise
Regards,Majid
 
G

Gérard Ducouret

Hello Majid,
Have you tried the "Date range" filter ?
If you want a full automatic filter, you'll have to program it with VBA

Gérard Ducouret
 
M

Majid

Hello Gérard
Yes, I am doing the date range. But each time my stakeholder have to
specify the current date which is the from date.

I am not sure if I can write the code.
Please advise
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assigning a value to one cell based on the date in another... And then doing it again 0
date range missing 3
ormula for weeks from a date to today? 4
Filter for dates up to the current date 1
Why does my start date not change on a dependent task? 3
Macro to filter on most current date. 5
Using Current Date with Filters 6
How to match progress with current day... 3

Top