Leap Year formula that won't automatically change to March 1

[Breizze1313]

I am trying to finalize some edits I did to a purchased Excel day planner file with holidays and such and the original creator did not list Leap Year in the "Holidays" section. I'm going to add some screenshots of what the formulas look like. All of this information is then moved via array formulas to the body of the planner. Using the standard DATE formula leap day auto changes to 3/1/XXXX of the year that is not a leap year. I would like non leap years to show nothing and every other formula i have tried to make that blank and not trigger into the main body of the planner keeps giving me an error. I swear this book is going to kill all my brain cells trying to chase formulas...

Leap Year NOT a Leap Year

 

[johnny51981]

Give this a go

=IF(OR(B84="",C84=""),"",IF(AND(MONTH(DATE(year,B84,C84))=B84,DAY(DATE(year,B84,C84))=C84),DATE(year,B84,C84),""))

 

[Tetra201]

The formula offered in Post #2 can be shortened to:

=IF(OR(B84="",C84=""),"",IF(MONTH(DATE(year,B84,C84))=B84,DATE(year,B84,C84),""))

 

[Breizze1313]

Both of those seem to be working amazingly! Thank you!