View Single Post
 
Old 08-27-2022, 03:43 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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)
Reply With Quote