Hi all,
I need your help in calculation because I'm getting confused in the middle of doing this calculation. The calculation goes like this:
Leave date ( DataCardValue_LeaveDate ) and Return Date (DataCardValue_ReturnDate) is manually entered by user.
Balance ( DataCardValue_Balance ) will show how many days is available. For example 'Allocated' is 20 and 4 days has been used, Balance ( DataCardValue_Balance ) will show 16 days.
No of Days ( DataCardValue_NoOfDays ) is the same as Used ( DataCardValue_Used ). It will show how many days is used. For example 'Allocated' is 20 and 4 days has been used, it will show 4 days on the data card value.
When user take one day leave (DataCardValue_LeaveDate) and return (DataCardValue_ReturnDate) on the same day, it should calculate as 0.5 days. How do I do this.
Also, Saturday and Sunday will be off day.
Many thanks for everyone help!!
@WarrenBelz @v-bofeng-msft @eka24 @v-qiaqi-msft @RandyHayes @Pstork1 @Rebetcha