Help me with simple IF stmt to test date within a range

macropod · #1 02-22-2014, 08:31 PM

You could use:

=IF(OR(A3<DATE(2013,10,1),A3>DATE(2014,12,31)),"NO ","YES")

tomseeley · #2 02-23-2014, 11:20 AM

Thank you! I didn't think of the OR statement. And I didn't know how to enter the year,month,day separated by commas either, so that Excel would interpret the info as a date! This does it for me!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
test	Cheekychino	PowerPoint	1	04-08-2013 09:09 PM
Write Test	dkub	Word VBA	1	07-21-2012 09:01 PM
Date Range Prompt	MikeWooZ	Excel	6	12-04-2011 02:10 PM
Vba, Is there a better way to test empty cells?	Hwyn	Excel Programming	2	11-14-2011 11:44 AM
Test after presentation?	barnkat	PowerPoint	0	08-13-2010 10:58 AM