Read date value and delete if...

[Hjahren]

Hello!

Does anyone have a the coding for a macro which does the following:
Reads date in column A, and delete entire row if the date is less or equal todays date + 2 days. Saturdays and mondays should not be included.

Cheers

[Living Knecht]

Hi,
what about this?

Please Login or Register  to view this content.

[Hjahren]

Thanks! I Believe this is working perfect. But I have to give my final verdict on thursday

[Hjahren]

I meant saturdays and sundays should not be included, I see that I wrote mondays. Does that differ? or did you expect it...

[Hjahren]

But I wrote exclude saturdays and mondays, but meant sundays....

[Living Knecht]

I did not see it :-D
I expected Saturday + Sunday.
Anyway, You can change the code as You wish. See vba help for the Weekday function

[Living Knecht]

However, if You want to test it, change the 7th line of the code to:

Please Login or Register  to view this content.

This will pretend, that it is friday, 26.11.2010 today and show You another result right now.

[Hjahren]

Thanks for your help and have a nice day.