Hi @Nguyen Huu ,
To avoid confusion, I will post a new reply for your reference.
My sample list structure with column types:
Calculated column syntax(Your available leave day and total day leave):
total day leave formula:
=IF(AND((WEEKDAY([End date],2))<(WEEKDAY([Start date],2)),((WEEKDAY([Start date],2))-(WEEKDAY([End date],2)))>1),(((DATEDIF([Start date],[End date],"D")+1))-(FLOOR((DATEDIF([Start date],[End date],"D")+1)/7,1)*2)-2),(((DATEDIF([Start date],[End date],"D")+1))-(FLOOR((DATEDIF([Start date],[End date],"D")+1)/7,1)*2)))
Flow:
Result:
Note:
Since there are spaces between my column names, so the internal name will have x0020, if your column has no spaces, remember to remove it.
You could also check the internal name of the column via list settings>click the column> check the internal name in URL like this:
Finally, if you want to calculate half day, you need to calculate based on hours, which is difficult to achieve in the subsequent process.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.