#1
|
|||
|
|||
If with multiple And
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()),"🎂","") I was first just trying this, but I believe that considers the year: Code:
=IF($D6=TODAY(),"🎂","") Code:
=IF(AND((MONTH($D6)=MONTH(TODAY())),(DAY($D6)=DAY(TODAY())),"🎂","")) |
#2
|
|||
|
|||
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())),"","") |
#3
|
|||
|
|||
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 |