I want something like that if I enter the date of joining in excel then the leave entitlement of the employee should be shown. Like someone who joined on 01/01/2022 and by 31/12/22 he will get 30 leaves. But if someone joins in August, then leave from August to December should be shown. What will be the formula, please help.
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.