View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default Date Comparison and IF statement

Hi!

These are not valid logical expressions:

is not greater than or equal to LS2
is great[er] than or equal to LO2


The logical comparisons you want can only appy to numbers.

<10
=10


<LS2 ??????? What's less than LS2?

Biff

"Holly" wrote in message
...
I would like to enter a formula to calculate the following

If an employee's date of hire is greater than 10 months from the last day
of
the year and their skill level is not greater than or equal to LS2 I want
a
return of 2

If their hire date is less than or equal to 12 months from the last day of
the year and their skill level is great than or equal to LO2 i want a
return
of 4

A little background: I am using this information to score/grade employees
on
knowledge level for year end reviews and will be using this formula from
year
to year I would like to not have to update the formula each year with the
correct year end date (In this case I am completing year end reviews for
1/1/05-12/31/05)