Hello There!

[Yeft]

I'm wondering if some one can help me with a macro that shows Aging more than 30 days Data.
Sheet name "Products"
Starting Row A3
Column 2 ("Input Dates") ----- the one with the dates to filter.

Thanks in advance!

 

[iggydarsa]

Hi Yeft,
Frist of all going forward please use the subject line to give a one line summary what the post is about rather than saying Hello. Just a friendly suggestion.

To answer your question I can think of 2 solutions.
1- you can use a helper column. by Column 2 if you mean Column B you can use this formula on an empty column: =TODAY()-B1. This will give you the day difference between "today" and the inputted date. then you can use filter.

OR

2- you can use a conditional formatting. Highlight the column (assuming B) then go to conditional formatting>New Rule> Use formula... > Type "=Today()-B1>30" on the box and select what kind of formatting you like it to show if it is more than 30 days by clicking on the Format button.

I hope these suggestions help.

 

[Yeft]

Hi Iggydarsa,

Thanks for helping! . It worked out.