Thread: IF this cell is between 2/1/2015-2/28/15, then do something
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default IF this cell is between 2/1/2015-2/28/15, then do something
Hi,

Am Thu, 19 Feb 2015 17:50:04 +0000 schrieb David Zman:

What is the conditional formula for a date driven statement?

=IF(AND(A1=DATEVALUE("01.02.2015"),A1<=DATEVALUE( "28.02.2015")),Your Formula,"")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote