Workday alternative

[chaboyski]

Hi Team,

currently i am using workday in a formula but it does not include counting the weekends. would there be another alternative formula for me to use? currently, instead of using -12 (which would be the count of days i should be using) i am using -8 to consider the 4 weekends (2 sat and 2 sun)

Book2
	B	C
2	12-Jul	26-Jun
3	12-Jul	30-Jun
Sheet1

Cell Formulas
Range	Formula
C2	C2	=WORKDAY(B2,-12)
C3	C3	=WORKDAY(B3,-8)

thank you in advance!

 

[Tetra201]

This?

=B2-12

 

[chaboyski]

This?

=B2-12

Hi @Tetra201 ,

my given is july 12. and what i can use for me to be able to get June 30 and still use -12

 

[Joe4]

Hi @Tetra201 ,

my given is july 12. and what i can use for me to be able to get June 30 and still use -12

July 12 is the date in cell B2.
So Tetra's formula seems to do exactly what you want.
If there is still some issue, you are going to need to explain it in more detail, as it is not clear to us.

 

[chaboyski]

July 12 is the date in cell B2.
So Tetra's formula seems to do exactly what you want.
If there is still some issue, you are going to need to explain it in more detail, as it is not clear to us.

i'm sorry about that. i'm too focused on the formula and i forgot the include why i need the workday formula. i would need it because i need to exclude holidays on the count as well.

 

[Tetra201]

If you need to exclude holidays from the day count yet include the weekends, then try:

=WORKDAY.INTL(B2,-12,"0000000",Holidays)

 

[chaboyski]

If you need to exclude holidays from the day count yet include the weekends, then try:

=WORKDAY.INTL(B2,-12,"0000000",Holidays)

Thank you for this, @Tetra201 . it worked for me!

just wanted to ask, what does the 7 zeroes means? would it be the days of the week to be counted?

 

[Tetra201]

You are welcome.

The seven-zero string means that all seven weekdays have to be treated as work days.

 

[chaboyski]

oh ok i got it. thank you @Tetra201