I want to write an "if" function in one cell to compare the date in another
then return a true or fuse statement:
IN CELL B1 I WRITE if(A1 >01/05/06,"TURE","FAUSE")
IS IS VALID ? IF A1 IS 05/05/06 THE RETURN SHOULD BE TURE
IF AI IS 03/02/04 RETURN SHOULD BE FAUSE ?
IT SEEMS TO ME THAT DO NOT WORK. HELP.

ANTHONY

[ Post a follow-up to this message ]

This is  FrontPage Newsgroup
- ask in an Excel newsgroup

--

 ________________________________________
_____
SBR @ ENJOY (-:              [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!"  (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontP...53/Default.aspx
 ________________________________________
_____


"IF FUNCTION WITH DATES" <IF FUNCTION WITH DATES@discussions.microsoft.com> 
wrote in message
news:CED905F1-D1A8-4BE2-8027-176F45F036F9@microsoft.com...
|I want to write an "if" function in one cell to compare the date in another
| then return a true or fuse statement:
| IN CELL B1 I WRITE if(A1 >01/05/06,"TURE","FAUSE")
| IS IS VALID ? IF A1 IS 05/05/06 THE RETURN SHOULD BE TURE
| IF AI IS 03/02/04 RETURN SHOULD BE FAUSE ?
| IT SEEMS TO ME THAT DO NOT WORK. HELP.
|
| ANTHONY

[ Post a follow-up to this message ]