MACRO for finding dates which are less than or equal to current date,

**drsantosh** · 10-08-2011, 09:24 AM

@Richard,

Thank you very much for your information. But can I use it in excel 2003 ?

Regards,

Santosh

**Richard Buttrey** · 10-08-2011, 09:35 AM

Not without modifying the formula in A3. The filter options in 2007 were much improved over 2003. Your header indicates you have 2007 which is why I used it.

In 2003 use in A3 and copied down

=IF(MONTH(B3)=MONTH(B4),"",IF(MOD(MONTH(B3),3)=0,"Q","M"))

Then filter column A for either "M" for month or "Q" for quarter.

**drsantosh** · 10-08-2011, 11:56 AM

@Richard,

Thank you very much.

but I am looking for dates on per day basis, not by month or quarter.

Also wana use this for entire excel sheet

so i guess macro will be helpful

Regards,

Santosh

**drsantosh** · 10-09-2011, 06:07 AM

can any1 help me out

**Richard Buttrey** · 10-09-2011, 06:49 AM

Sorry, I inadvertently gave you an answer to another thread.

In 2003 you can use Data Autofilter Custom. Select your date column, then select the "Is less than or equal to" option and enter the current date then OK.

Regards