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.
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.