Labor Days

[jdecastro]

Here in Colombia we work Saturdays!!!

I need a Formula to make up for the time worked without taking into account Sundays.

I can't use the formula of labor days with vacations, I need an elaborate formula

Thanks

 

[texasalynn]

post a sample of your data and the results you would expect

 

[jdecastro]

Example:

I worked from April 18th to April 25th

So How many days did I work? Monday through Saturday (6) and Monday (1)

Result: 7

 

[jasonb75]

With start date in A1, end date in A2

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))>1))

 

[T. Valko]

Example:

I worked from April 18th to April 25th

So How many days did I work? Monday through Saturday (6) and Monday (1)

Result: 7

One way...

A2 = start date
B2 = end date

=SUM(INT((WEEKDAY(A2-{2,3,4,5,6,7})+B2-A2)/7))

 

[jdecastro]

It gives me the number 8 when it should give me the number 7

 

[jasonb75]

It gives me the number 8 when it should give me the number 7

Don't know if you're referring to my suggestion or T.Valko's, but I get 7 from both.

 

[jdecastro]

missed parenthesis!!!!!

thanks a lot both,

Both work great

 

[barry houdini]

Which version of Excel are you using? In Excel 2010 you can use NETWORKDAYS.INTL function, i.e.

=NETWORKDAYS.INTL(A2,B2,11)

 

[jdecastro]

Can you please explain how this two formulas work?