FrontPage Server Extensions for Windows - I WANT TO WRITE A "IF" FUNCTION THAT CHECK THE DATE IN ONE CELL A

Author

I WANT TO WRITE A "IF" FUNCTION THAT CHECK THE DATE IN ONE CELL A

IF FUNCTION WITH DATES

2006-03-15, 5:52 pm

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

Stefan B Rusynko

2006-03-16, 7:48 am

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