|
|
#1
08-26-2022, 10:55 PM
|
||||
|
||||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Extracting date, month & year from a text string without using date format Help | Haha88 | Excel | 5 | 08-06-2021 01:19 PM |
 Empty date cell shows wrong month & year
|
Learner7 | Excel | 3 | 06-16-2019 11:09 AM |
|
Find Date Month
|
charlesdh | Excel Programming | 11 | 07-24-2018 06:11 PM |
| Excel day date month year Function | greginky | Excel | 1 | 01-05-2016 02:19 AM |
| Formula to count entries as per month, year and submission wise from different sheets | pinkacidpunk | Excel | 1 | 05-28-2013 08:26 AM |
Windows 10 
Office 2019
Threaded Mode