So if I take todays date and I want to loop thru column A that has various date/time records formatted like "10/3/2014 12:15:23 PM" and pull only the records that our within 7 days of todays date how can I do that. I will put those values into column B but I'm hung up on the date thing.