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

		Microsoft Office Forums > Microsoft Excel > Excel
Help me with simple IF stmt to test date within a range

02-22-2014, 08:31 PM

macropod

Windows 7 32bit Help me with simple IF stmt to test date within a range

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

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

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:26 AM.