Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-23-2020, 12:06 AM
PrincessApril PrincessApril is offline If with multiple And Windows 10 If with multiple And Office 2019
Competent Performer
If with multiple And
 
Join Date: Nov 2019
Posts: 102
PrincessApril is on a distinguished road
Default 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()),"🎂","")
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!
Reply With Quote
  #2  
Old 10-23-2020, 12:46 AM
Purfleet Purfleet is offline If with multiple And Windows 10 If with multiple And Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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())),"��","")
Reply With Quote
  #3  
Old 10-23-2020, 04:59 AM
PrincessApril PrincessApril is offline If with multiple And Windows 10 If with multiple And Office 2019
Competent Performer
If with multiple And
 
Join Date: Nov 2019
Posts: 102
PrincessApril is on a distinguished road
Default

That it does--thanks so much!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
If with multiple And Combine Multiple Documents from Multiple Folders while also inserting title Lumberjax Word VBA 14 03-07-2023 07:12 AM
If with multiple And 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
If with multiple And 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
If with multiple And Copy Multiple Rows to new workbook when multiple criteria is met. flds Excel Programming 5 09-30-2014 09:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft