| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF on dates
I am usually a whix with IF statements, but this one has me stumped.
I have a user who wants this: =IF(A36/28/2005,"PAST","FUTURE") However, it seems that no matter what date we enter, it still shows all dates as "PAST". I doubl;e checked the formatting of the date column (where the actual data is supposed to go) and made sure it was a basic date. This seems so basic, why can't I fix it? -Monica |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
| How do I get Excell to sort dates that range from 1800 to 1900's | New Users to Excel | |||
| How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
| due dates | New Users to Excel | |||
Threaded Mode
