Annual Leave calculation

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
 
K

kc-mass

=IIF(Date-Starting date>5*360,2.5,IIF(Date-Starting
date>1*360,2.5,IIF(Date-Starting date>0.5*360,2)))
 
K

KARL DEWEY

Maybe this way --
=IIF(Date()-[Starting date]>5*360,2.5,IIF(Date()-[Starting date]>1*360,2.5,2))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top