Annual Leave calculation

  • Thread starter Thread starter Tia
  • Start date Start date
T

Tia

DEAR ALL,

i am trying to calculate the annual leave for the employees. i have
been using the excel and i used to use this:
=IF(TODAY()-Starting date>5*360,2.5,IF(TODAY()-Starting
date>1*360,2.5,IF(TODAY()-Starting date>0.5*360,2)))

How can i translate the same to access
 
=IIF(Date-Starting date>5*360,2.5,IIF(Date-Starting
date>1*360,2.5,IIF(Date-Starting date>0.5*360,2)))
 
Maybe this way --
=IIF(Date()-[Starting date]>5*360,2.5,IIF(Date()-[Starting date]>1*360,2.5,2))
 
Back
Top