| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Thanks Bob. Problem solved.
"Bob Phillips" wrote: =IF(D2<--"1994-09-01","Secondary","Primary") -- HTH Bob Phillips "Karen Saberi" <Karen wrote in message ... I want to use the "IF" function to allocate students to groups based on their date of birth. I have tried doing this using the format IF(D2<1/9/1994,"Secondary","Primary") D2 is the cell with the first student's date of birth. I can't get the result I want, as all students come out as "primary" regardless of their date of birth, and even the first student was born in 1989. Can anybody help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) | |||
| dates in Excel 2003 | Excel Discussion (Misc queries) | |||
| how do I show dates in a column in an excel worksheet? | Excel Discussion (Misc queries) | |||
Hybrid Mode
