Highlight birthdays

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" <roger@technologyNOSPAM4u.co.uk> wrote in message
news:OQSrxlEEGHA.208@tk2msftngp13.phx.gbl...
> 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 <jeff.kelly@tiscali.nl> 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
>
>

0),DAY(A1)-DAY(TODAY())<
<0),DAY(A1)-DAY(TODAY())<
> wrote
>> 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(TOD
> AY())< =14)
>> --
>> Regards
>> Roger Govier
>> jocker <jeff.kelly@tiscali.nl> 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

Hi Bob

You're quite right.
My formula is absolute rubbish, as it would also give incorrect results
to any other days in the next month which are less than
Today's DAY().

Yours is the far nicer (and correct) solution.
Happy New Year to you.


--
Regards

Roger Govier



Bob Phillips <bob.phillips@notheretiscali.co.uk> wrote:
> 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" <roger@technologyNOSPAM4u.co.uk> wrote in message

Hi Bob

Apologies for that last response, I have made some changes to OE6 and it
is putting some of my responses in weird positions relative to the
original post

It should have appeareed as

You're quite right.
My formula is absolute rubbish, as it would also give incorrect
results to any other days in the next month which are less than
Today's DAY().

Yours is the far nicer (and correct) solution.
Happy New Year to you.



--
Regards

Roger Govier



Roger Govier <roger@technologyNOSPAM4u.co.uk> wrote:
> 0),DAY(A1)-DAY(TODAY())<
> <0),DAY(A1)-DAY(TODAY())<
>> wrote
>>> 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(TOD
>> AY())< =14)
>>> --
>>> Regards
>>> Roger Govier
>>> jocker <jeff.kelly@tiscali.nl> 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
>
> Hi Bob
>
> You're quite right.
> My formula is absolute rubbish, as it would also give incorrect
> results to any other days in the next month which are less than
> Today's DAY().
>
> Yours is the far nicer (and correct) solution.
> Happy New Year to you.
>
>
> --
> Regards
>
> Roger Govier
>
>
>
> Bob Phillips <bob.phillips@notheretiscali.co.uk> wrote:
>> 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" <roger@technologyNOSPAM4u.co.uk> wrote in message