Birthday Alert

D

dhouston1000

I have a worksheet that contains client info including their birthdays.

I would like a column to alert me at least 5 days before their upcomin
bithday so as to contact them about special incentives and offers
 
B

Bernie Deitrick

dhouston1000,

Say your birthdays are in column C, starting in row 2.

In column D, row 2, use the formula

=IF(AND(DATE(YEAR(NOW()),MONTH(C2),DAY(C2))>TODAY(),
DATE(YEAR(NOW()),MONTH(C2),DAY(C2))<TODAY()+6),"Birthday Notice!","")

Take out any line wraps put in by your newsreader, then copy the formula down column D to match your
column of birthdays.

HTH,
Bernie
MS Excel MVP
 
T

tghcogo

You don't need another column necessarily, you could use conditional
formatting to make the birthday cell change to a different background
or font colour 5 days before the due date. just insert somewhere (eg H1
on the spreadsheet)

=TODAY()

conditionally format the "birthday" cell so that :- cell value is less
than or equal to $H$1+5

Apply the colour change format


nb. The birthday cells must be date formatted, and The Birthday cell
should be edited to the next birthday event due, once you have
completed your contact action.
 
Top