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.

It all depends on your layout and formatting
Perhaps post a small sheet with some examples?
Also, do you mean "before May 15" in the same year?
Are you still using XL 2019?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I am using Office 365. I could not exactly say May 15, 2022. I have tried several formula under the Bonus column since yesterday but no success.
Perhaps the attached sample sheet might help.
Thank you.

Attached Files

Find Month and Date.xlsx (10.6 KB, 6 views)

What you mean by "... I would like my formula to find all the dates ..."

Do you want the formula to return "Yes" or "No" for every row of table depending the date in some column of same row? When yes, then probably something like (assuming the dates are in column A of table, and they aren't datestrings, but are real dates)

Thank you Arvi. I had been doing the formula using the TEXT function hence I kept on getting erroneous answers.

Could you please amend your profile accordingly? 365 has a lot of new functions and has PQ, whereas other versions only have PQ when installed by the user. Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post