|
|
#5
08-27-2022, 03:43 AM
|
|||
|
|||
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) Code:
=AND(DAY(A2)<=15,MONTH(A2) = 5) 
|
|
|
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 8 
Office 2016
Threaded Mode