| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date trouble
cell A2 has the date 3/9/2007
When I test the following formula - =(A2+45)=4/27/2007 I get True, but I should get false. AlSO, when I put in =4/23/2007<4/27/2007 I get false. Both expressions should evaluate to true. What is going on? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date trouble | Excel Worksheet Functions | |||
| Trouble formatting date | Excel Worksheet Functions | |||
| Trouble formatting Date data | Charts and Charting in Excel | |||
| Excel date format trouble | Excel Discussion (Misc queries) | |||
| trouble with date | Excel Worksheet Functions | |||
Threaded Mode
