LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default Dates and If Function

I need to check a cell to see that it does not contain a certain date. There
are 12 dates that the cell cannot be.

B12 = Date that I am testing to make sure that it isn't one of the dates in
my formula.

I have tried =IF(OR(B12<"4-5-2009", B12<"5-7-2009", "Y","N")

I can't get this to work. The cell format for B12 is "5-Apr-2009.
That differs from what appears in the top box when I click on the cell. It
shows as 4/5/2009. Could that make a difference? I have tried both ways,
and I can't get this to work. Any help would be greatly appreciated!

Thanks,

Ginger
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If Function with Dates Bev Excel Worksheet Functions 1 September 22nd 08 10:25 PM
If Function and Dates Laura Logan Excel Worksheet Functions 13 March 12th 08 01:31 PM
If Between Dates Function - please help Mitchell_Collen via OfficeKB.com Excel Worksheet Functions 5 June 14th 07 11:51 PM
IF function using dates ? barnsey11 Excel Worksheet Functions 2 January 15th 06 04:01 PM
if function with dates Brad Excel Discussion (Misc queries) 1 January 10th 05 10:49 PM


All times are GMT +1. The time now is 02:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"