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

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

Hello Everyone,

I am new here, as well am new to VBA...

I wana create macro which help to find dates which are less than or equal to current date.

Can anyone help me for this?

Also please suggest simple book for MACRO in excel

Regards,

Santosh

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

Hi,

Do you really need a macro? Standard Data Filter will allow you to select the date column and filter dates that are equal to the current date - as well as many other criteria as well.

Regards

**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

**royUK** · 10-09-2011, 06:11 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!