NETWORKDAYS.INTL Function in Excel in Hindi
In this video we learn NETWORKDAYS.INTL function, NETWORKDAYS.INTL calculates the number of working days between two dates. NETWORKDAYS.INTL can optionally exclude a list of holidays and provides a way to specify which days of the week are considered weekends.
Purpose:-
Get work days between two dates.
Return value:-
A number representing days.
Syntax:-
=NETWORKDAYS.INTL (start_date, end_date, [weekend], [holidays])
Arguments:-
start_date - The start date.
end_date - The end date.
weekend - [optional] Setting for which days of the week should be considered weekends.
holidays - [optional] A reference to dates that should be considered non-work days.
NETWORKDAYS.INTL takes four arguments: start_date, end_date, weekend, and holidays. The start_date, end_date and holidays arguments must be valid Excel dates. The weekend argument controls which days of the week are considered weekends, and therefore not included in the count. Holidays are also treated as non-working days and will not be included in the result.
Both the weekend and holidays arguments are optional. By default, NETWORKDAYS.INTL will exclude Saturdays and Sundays, but this can be customized as explained in video. To exclude holidays, supply a range that contains non-working dates for the holiday argument.
In case of any simple or complicated "EXCEL" QUERY, You can join our WhatsApp Group for instant solution @ https://chat.whatsapp.com/BymUIDEt3ME...
-----------------------------------------------------------------------------------------------------------------------
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
Please Subscribe Our Channel
https://www.youtube.com/channel/UC8Vu...
#Date_Formulas
#Networkdays_intl
#Networkdays
Смотрите видео NETWORKDAYS.INTL Function in Excel in Hindi онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel With Ravi 20 Июнь 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,016 раз и оно понравилось 41 людям.