Another example

=AND(DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))=TODAY( ),DATE(YEAR(TODAY()),MONTH
(A1),DAY(A1))-TODAY()<=14)

Roger, yours seems to highlight 1st and 2nd Feb. Haven't looked at why.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Roger Govier" wrote in message
...
Hi

There may be a simpler formula, but the following seems to work

=AND(MONTH(A1)=MONTH(TODAY())+(DAY(A1)-DAY(TODAY())<0),DAY(A1)-DAY(TODAY())<
=14)


--
Regards

Roger Govier



jocker wrote:
Using conditional formatting how would I highlight birthdays coming up
within the next 14 days.
I can't use < today()+14 since birth year is in the past. I don't
mind using VBA if this helps