How to detect if a date is within 30 days of today's date?

Hi All,

If I have a date variable bigDate="04/11/16", is there a way in VBA, to code if that date falls with in 30 days of today's date?

(So that would mean if today's date is 4/7/16, or 4/20/16, it should return True ... but if today's date is 5/30/16, it should return false)

Thanks so much,
JMC

Hi SHG & Richard,

Thank you so much! This worked perfectly!

And Richard: Holy moley! This was asked within 3 minutes of my post? Crazy! I also thought it might be a popular question, but came to no avail on a search...perhaps if I would have waited a few minutes longer! :-) Thanks again!!

JMC