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

FAQ

Thread Tools

Display Modes

02-23-2014, 02:13 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,518

Quote:

Originally Posted by Pecoflyer

Actually statements like A3>="10/1/2013" also work

But, in this case, only on a PC whose regional settings use the MM/DD/YYYY format! Move to a PC using DD/MM/YYYY settings and you'll get 'interesting' results. The DATE function is impervious to such subtleties...

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

« Previous Thread | Next Thread »

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 09:10 PM.