LearnExcel&VBA
New Member
Hi All,
I am looking for a formula which counts the Employee leave throughout the complete years dates as available in attached sheet
I have created a formula but do not know how to add the Joining date available in cell B3 and Completion date available in cell C3 in the formula to count the employee leaves between the joining and completion dates. along with the condition if D2 = Probation then it should show the probation leaves if = Complete then it should show the leaves after completion date.
Any help would be highly appreciated.
I am looking for a formula which counts the Employee leave throughout the complete years dates as available in attached sheet
I have created a formula but do not know how to add the Joining date available in cell B3 and Completion date available in cell C3 in the formula to count the employee leaves between the joining and completion dates. along with the condition if D2 = Probation then it should show the probation leaves if = Complete then it should show the leaves after completion date.
Any help would be highly appreciated.
Attachments

26.5 KB Views: 13