Hi Woodkat
Something along the lines of
=IF(AND(DATE(2004,MID(A1,5,2),RIGHT(A1,2))TODAY() +14,DATE(2004,MID(A1,5,2),RIGHT(A1,2))<TODAY()+21) ,"card","")
Cheers
JulieD
"Woodkat" wrote in message
...
what if the dates in column A are stored as text in the YYYYMMDD format?
"Bill Martin" wrote:
I have a column of birthdays and would like to be able to filter only
those
birthdays that occur in the next 14-21 days so we can mail cards. Is
there a
way to do this?
How about this. Assume the birthdays are in column A in date format such
as
9/23/1950. Then create a second column B where
B1 = if(mod(days360(today(),A1),360) < 21,"Send Card!","")
Then just copy that all the way down the B column.
Good luck...
Bill -- (Remove KILLSPAM from my address to use it)
|