Excel validation using multiple conditions

I

imr

Hi

I am faced with a situation where i need some help. I a
having a worksheet which calculates the number of leave accumulated fo
an employee.

when we choose a particular option for the employee, say "xx" whe
he/she works overtime, right now i have set up a formula to calculat
the number of times this occurs.

I need help to further enhance this functionality. Based on the date o
which the "xx" is entered into a particular employee's row, i need t
create another column which validates the particular date and check
whether more than a month has elapsed from the date of entering th
value of "xx", and this has to get counted in another cell.

Could anyone please let me know a solution?

Regards
IM
 
Top