excel spreadsheet
Posted by gregory love on November 18, 2001 10:53 PM
i am tring to fo a formula that would allow me to calulate days ex. if 1/23/01 is = > than 1/23/01 please show pass, if 1/23/01 is < 1/24/01 = fail i need the formula for windows 2000. as simple as possible.
Posted by Aladin Akyurek on November 19, 2001 5:14 AM
Not sure this is what you want, but if you have date in A1 which you want to compare to a date in B1, then
in C1 enter: =IF(A1 >= B1, "pass", "fail")
Aladin
