When importing a query dates are entered in excell as text (YYYYMMDD). Is
there a way to control how the query imports the data? If not, I am having
difficulty creating a formula that would tell me which birthdays occur 2-3
weeks from today.

My old formula worked using the text import and converting the text column
to the correct date format:
=IF(AND(DATE(YEAR(TODAY()),MONTH(P2),DAY(P2))=TOD AY()+7,DATE(YEAR(TODAY()),MONTH(P2),DAY(P2))<=TODA Y()+14),"Send Card!","")). Any one have an idea?