Forum Discussion

Rehanparkar's avatar
Rehanparkar
Copper Contributor
Oct 03, 2023

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...
excel
Formulas and Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Oct 03, 2023

Rehanparkar 

Try this.

=SUM((DATEDIF(G4,TODAY(),{"M","MD"})+{0,1})/{1,30}*2.5)
  • Rehanparkar's avatar
    Rehanparkar
    Copper Contributor
    Oct 04, 2023
    If I change the date in column H, the number doesn’t change.
    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Oct 04, 2023
      I didn't use column H. I used TODAY(). You can change it in the formula.

Resources