| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
dates and if statement work on one sheet, not on another
Something's screwy. Two dates in different cells:
a1: 1/1/2003 b1: 10/29/2001 =a1-b1: 429 =b1-a1: -429 =if(a1<b1,1,0) 1 How can the last formula return a 1???? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Can I track changes in a Work Sheet? | Excel Worksheet Functions | |||
| I really need help! Changing work period start dates | Excel Worksheet Functions | |||
| When copying dates to another sheet the dates are different | Excel Worksheet Functions | |||
| I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
| How do I ensure dates inputted are during the work week? | Excel Worksheet Functions | |||
Threaded Mode
