Leave Earn Per Month

[mauigarcia]

Hi guys,

Newbie here, I just want you to help me. Here is the situation, If I was hired last year March 6, 2017, they have given me 5days of leave (SL/VL) per year. How many days I've earned for last year that I can use this year? I just want to compute my leave earn daily by putting a formula than will apply as well for my co employee, but I don't know how.

Please help guys.
Thank you in advance.

 

[snjpverma]

how many days leave do u get per month?

 

[mauigarcia]

We have 5days a year so per month I get 0.4167.

 

[snjpverma]

Assuming your hire date is in Cell A2. Try this,

=DATEDIF(A2,TODAY(),"m")*5/12

 

[mauigarcia]

Thank you so much @snjpverma, it works. Sorry for late response.

 

[snjpverma]

mauigarcia Thanks for the update