Forum Discussion
help related to leave balance formula on urgent basis
I want to calculate the total leave balance from the date of joining till today(including today's day) 2.5 leaves per month (irrespective of days in the month) So for Dr Hazem, the correct number s...
Add this Funtion it will work
=(ROUND((H4-G4)/30,0)*2.5)+(DAY(H4)*2.5)/30
*Note: change the cell format to General
Regards
=(ROUND((H4-G4)/30,0)*2.5)+(DAY(H4)*2.5)/30
*Note: change the cell format to General
Regards
But if I change the current date to April ,30 2023
then it doesn’t show 12.5 while it should be 10Basically if i put any date above 15 then number goes wrong
