Microsoft Office Forums - View Single Post - [Solved] Formula to find Month and Day but excluding the year in a date

Thread: [Solved] Formula to find Month and Day but excluding the year in a date

View Single Post

Old

08-26-2022, 10:55 PM

Marcia

Marcia is offline

Marcia uses Windows 10

Windows 10 Marcia uses Office 2019

Marcia uses Office 2019

Office 2019

Expert

The original poster

Join Date: May 2018

Location: Philippines

Posts: 527

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Default

Formula to find Month and Day but excluding the year in a date

Hi. In a column of dates spanning several years, I would like my formula to find all the dates falling on or before May 15 regardless of year.
=If Date is <=May 15, "x","y")
How do I place the "May 15" in a formula?
Thank you.

Reply With Quote