If with multiple And

PrincessApril · #1 10-23-2020, 12:06 AM

Hi all,

I am attempting to display a birthday cake icon in Column C when the date of birth in Column D matches today's month and day, disregarding the year.

I got it working for when just the month matches, with this:

Code:

=IF(MONTH($D6)=MONTH(TODAY()),"🎂","")

However, I can't seem to trigger only when the exact month and day match.

I was first just trying this, but I believe that considers the year:

Code:

=IF($D6=TODAY(),"🎂","")

Then I tried doing multiple conditions by combining If and And, as follows, but I got an alert error saying "There's a problem with this formula. If you're not trying to type a formula..."

Code:

=IF(AND((MONTH($D6)=MONTH(TODAY())),(DAY($D6)=DAY(TODAY())),"🎂",""))

I'm guessing I'm just missing something simple but can't seem to figure it out.

Any help would be greatly appreciated. Thank you all as always!

Purfleet · #2 10-23-2020, 12:46 AM

I think you were just over keen on your brackets

This seems to work

=IF(AND(MONTH($D6)=MONTH(TODAY()),DAY($D6)=DAY(TOD AY())),"��","")

PrincessApril · #3 10-23-2020, 04:59 AM

That it does--thanks so much!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine Multiple Documents from Multiple Folders while also inserting title	Lumberjax	Word VBA	14	03-07-2023 07:12 AM
Mail Merge Student Transcript - Multiple Years from multiple sheets	aizah2018	Mail Merge	1	11-11-2018 01:27 AM
Mail Merge to multiple employees in multiple locations as PDF by location	GFiz	Mail Merge	1	05-13-2017 08:01 PM
I need to add multiple values based on multiple criteria in a cell not sure what to do	AUHAMM	Excel	3	10-27-2014 09:11 PM
Copy Multiple Rows to new workbook when multiple criteria is met.	flds	Excel Programming	5	09-30-2014 09:58 AM