Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

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

All times are GMT -7. The time now is 09:42 AM.


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