Hi there,

I need a formula which should be quite straight forward (in my head) but if I do it the way I think it should work it comes back with an error. I hope you can help me

I have the following fields:
Name
Start Date
Eligible (this should be a formula)
Today's Date

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?

Many thanks,
Ramona