Forum Discussion
Formula dias.lab.intl
Hola Estoy intentando usar esta fórmula para sumar a una fecha específica solo los días hábiles para lograr hacer seguimiento a un proyecto, pero el resultado que me arroja es un numero negativo...
Julian1803 There is a semi-colon missing in the formula before F3. The optional third argument that indicates which days are to be seen as the weekend is not used in your case
=D I A. LAB. INTL(D3; E3; 1;;F3)
Now, the end result may initially be displayed as 45405, but that's just the day number is Excels calendar. Format G3 as a date and it should show as April 23, 2024. See attached.