| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF Statement with Dates.
As part of a method to try and create a summary sheet, I have an IF
statement setup to tell me the date period. Currently, it states: =IF('OC''s'!I35/5/2007,1,0) Basically state "1" if the date is greater than May 5, 2007. For some reason, it responds with a "1" anytime there is anything written into the cell, which is driving me nuts. Also, what would I do if I want to have it populate a "1" if the date in that cell is between May 5th and May30th? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement for Dates | Excel Worksheet Functions | |||
| IF Statement Using Dates | Excel Discussion (Misc queries) | |||
| If statement with dates | New Users to Excel | |||
| IF statement with two dates | Excel Discussion (Misc queries) | |||
| If Statement and Dates | Excel Worksheet Functions | |||
![cjwenngatz@gmail.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
