Calculation of working days between two dates
logan13
-
michel_m Posted messages 18903 Registration date Status Contributeur Last intervention -
michel_m Posted messages 18903 Registration date Status Contributeur Last intervention -
Hello,
Everything is said in the title or almost, I am using Excel 2010, and I want to be able to calculate the number of working days (including Saturdays, NOT workdays) between two dates. Does anyone know the necessary formula? The one from Microsoft help, for some reason, does not work for my calculation... I don't understand.
Thanks in advance.
Configuration: Windows 7 / Chrome 51.0.2704.103
Everything is said in the title or almost, I am using Excel 2010, and I want to be able to calculate the number of working days (including Saturdays, NOT workdays) between two dates. Does anyone know the necessary formula? The one from Microsoft help, for some reason, does not work for my calculation... I don't understand.
Thanks in advance.
Configuration: Windows 7 / Chrome 51.0.2704.103
3 réponses
Hello
=NETWORKDAYS.INTL(B1,C1,11,jf)
jf > address of the list of holidays to exclude (or name of the field)
11 code to exclude Sunday
see in Excel help for setting up the formula the list of codes for this formula which defines the type of weekends to consider:
formulas tab / date and time / select the label and in the new window click on "help on this function"
regards
The quality of the answer mainly depends on the clarity of the question, thank you!
=NETWORKDAYS.INTL(B1,C1,11,jf)
jf > address of the list of holidays to exclude (or name of the field)
11 code to exclude Sunday
see in Excel help for setting up the formula the list of codes for this formula which defines the type of weekends to consider:
formulas tab / date and time / select the label and in the new window click on "help on this function"
regards
The quality of the answer mainly depends on the clarity of the question, thank you!
