Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-23-2014, 12:42 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help me with simple IF stmt to test date within a range Windows 7 64bit Help me with simple IF stmt to test date within a range Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default


Actually statements like A3>="10/1/2013" also work
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #2  
Old 02-23-2014, 02:13 PM
macropod's Avatar
macropod macropod is offline Help me with simple IF stmt to test date within a range 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,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Pecoflyer View Post
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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
test Cheekychino PowerPoint 1 04-08-2013 09:09 PM
Help me with simple IF stmt to test date within a range Write Test dkub Word VBA 1 07-21-2012 09:01 PM
Help me with simple IF stmt to test date within a range Date Range Prompt MikeWooZ Excel 6 12-04-2011 02:10 PM
Help me with simple IF stmt to test date within a range 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 01:06 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