On Thu, 9 Aug 2012 11:45:33 +0000, Ramona88 wrote:

Criteria:
Employees that have been with the company for less than 1 year - return
0
Employees that have been with the company between 1 and 2 years -
return 3
Employees that have been with the company for 2+ years - return 5

Is that do-able?

Of course it is. What formula did you try?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...