Hi
you could use 'Data - Text to columns' afterwards to convert these
values to a real date value
--
Regards
Frank Kabel
Frankfurt, Germany
"Woodkat" schrieb im Newsbeitrag
...
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(TODA
Y()),MONTH(P2),DAY(P2))<=TODAY()+14),"Send Card!","")). Any one have
an idea?
|