Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi All,
I need to compare a date in "Driver's License Expires" column to a specific date like, 10/31/08, and if the expiration date is less than this date to put an "X" in a separate column. I want to mark those rows where an employee's driver's license has expired or will expire by 10/31/08. I've tried using an IF statement but the results are not correct. It doesn't appear that the full date is being compared. Any help would be appreciated!! -- JWeaver |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing Dates | Excel Discussion (Misc queries) | |||
Comparing two dates in one column | Excel Discussion (Misc queries) | |||
Comparing 3 dates | Excel Worksheet Functions | |||
Comparing dates | Excel Worksheet Functions | |||
Comparing Dates using Greater Than and Less than | Excel Discussion (Misc queries) |