Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-26-2022, 10:55 PM
Marcia's Avatar
Marcia Marcia is offline Formula to find Month and Day but excluding the year in a date Windows 10 Formula to find Month and Day but excluding the year in a date Office 2019
Expert
Formula to find Month and Day but excluding the year in a date
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia 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
  #2  
Old 08-26-2022, 11:03 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Formula to find Month and Day but excluding the year in a date Windows 7 64bit Formula to find Month and Day but excluding the year in a date Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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?
__________________
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
Reply With Quote
  #3  
Old 08-27-2022, 12:40 AM
Marcia's Avatar
Marcia Marcia is offline Formula to find Month and Day but excluding the year in a date Windows 10 Formula to find Month and Day but excluding the year in a date Office 2019
Expert
Formula to find Month and Day but excluding the year in a date
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

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
File Type: xlsx Find Month and Date.xlsx (10.6 KB, 4 views)
Reply With Quote
  #4  
Old 08-27-2022, 03:43 AM
ArviLaanemets ArviLaanemets is offline Formula to find Month and Day but excluding the year in a date Windows 8 Formula to find Month and Day but excluding the year in a date Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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
  #5  
Old 08-27-2022, 04:37 AM
Marcia's Avatar
Marcia Marcia is offline Formula to find Month and Day but excluding the year in a date Windows 10 Formula to find Month and Day but excluding the year in a date Office 2019
Expert
Formula to find Month and Day but excluding the year in a date
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Thank you Arvi. I had been doing the formula using the TEXT function hence I kept on getting erroneous answers.
Reply With Quote
  #6  
Old 08-27-2022, 06:23 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Formula to find Month and Day but excluding the year in a date Windows 7 64bit Formula to find Month and Day but excluding the year in a date Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Quote:
Originally Posted by Marcia View Post
I am using Office 365.
Thank you.
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
__________________
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
Reply With Quote
Reply

Thread Tools
Display Modes


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
Formula to find Month and Day but excluding the year in a date Empty date cell shows wrong month & year Learner7 Excel 3 06-16-2019 11:09 AM
Formula to find Month and Day but excluding the year in a date 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:17 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft