There is a mistake in the formula. Should have made the "holiday range" static... formula should be like this for calculation to work properly: =NETWORKDAYS(B6,C6,$F$6:$F$20)
@manojsrikanth8663
Жыл бұрын
That is what I noticed.. thanks.. 👍
@Sbudarh_P
Жыл бұрын
I noticed that too because it will shift when dragging down the formula
@rvreddy4855
10 ай бұрын
Perfect note. I noticed the same and started checking the comments 😂
@cattac6561
Жыл бұрын
If I only work in holidays, how to calculate the numbers of days from period starting date and end date
@illururajabharat810
Жыл бұрын
Hi, How to calculate Difference between two dates and time with working hours in excel?
@sarfaraj.
Жыл бұрын
Sir ye excel ka kon sa version hai 2007 ya 2010
@LearnExceltoexcel
Жыл бұрын
Excel 365
@Pied.Piper125
Жыл бұрын
Please make a video on how to generate the end date instead
@LearnExceltoexcel
Жыл бұрын
Noted.
@surajverma6006
Жыл бұрын
Sir, in respect of counting no. Of days joining on 4th day and left on 9th day so total work days are 6 if less one holiday also so answer is 5days. Why it's showing 4.
@LearnExceltoexcel
Жыл бұрын
As mentioned in the pinned comment, holidays range should have been static but I forgot to do it. That's why for two date ranges, calculation is off. Check pinned comments for the correct formula.
@vipinsahu4961
Жыл бұрын
U forgot to freeze Holiday range
@LearnExceltoexcel
Жыл бұрын
🤦🏻♂️🤦🏻♂️🤦🏻♂️..... Should have gone ahead with named range.... Skipped it made a mistake...
@vipinsahu4961
Жыл бұрын
@@LearnExceltoexcel name range would be a tough concept to understand
@LearnExceltoexcel
Жыл бұрын
That's why skipped it as tutorial was quite simple... But made a mistake by skipping it 🤦🏻♂️ anyways... That also means we have another day to Excel better ☺️
Пікірлер: 17