Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-18-2017, 06:32 AM
taryn taryn is offline IF fomula with dates Windows XP IF fomula with dates Office 2010 64bit
Novice
IF fomula with dates
 
Join Date: Jan 2015
Location: Gibraltar
Posts: 21
taryn is on a distinguished road
Default IF fomula with dates

Hello



I am trying to generate a formula which will give me a "Yes" answer if a date in a cell is in the same month and year as a date in a second cell and a "No" answer if it isn't. The day of the month is irrelevant. Assume date 1 is in Cell A1 and date 2 is in cell B2.

Thanks.

Taryn
Reply With Quote
  #2  
Old 08-18-2017, 07:15 AM
ArviLaanemets ArviLaanemets is offline IF fomula with dates Windows 8 IF fomula with dates Office 2016
Expert
 
Join Date: May 2017
Posts: 581
ArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really nice
Default

=and(year(a1)=year(b2),month(a1)=month(b2))
Reply With Quote
  #3  
Old 08-18-2017, 09:13 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline IF fomula with dates Windows 7 64bit IF fomula with dates Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,432
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Alternatively =if(eomonth(a1)=eomonth(b2),"yes","no")
Reply With Quote
  #4  
Old 08-21-2017, 04:34 AM
taryn taryn is offline IF fomula with dates Windows XP IF fomula with dates Office 2010 64bit
Novice
IF fomula with dates
 
Join Date: Jan 2015
Location: Gibraltar
Posts: 21
taryn is on a distinguished road
Default

Thank you for your help.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofill dates - how can I get the same date and consecutive dates? Exhale Excel 3 04-05-2016 03:11 AM
IF fomula with dates Changing Actual Finish dates changes original Finish dates SomewhereinTX Project 3 12-20-2013 10:25 AM
Excel Fomula to search for a string and display value from different column zeeshanbutt Excel 1 07-29-2012 12:48 AM
Adding dates mkkram Word 0 11-27-2006 09:18 AM
Help with Max or lookup fomula to return a name forAmaxValue dutch4fire23 Excel 0 07-28-2006 01:12 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:18 PM.


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