I’m looking for a formula that acts like networkdays in that I can set my holiday exclusion list, but I want to count weekends. Any help?

[ihipera_rs]

I am wanting to know the difference between two dates, including weekends but excluding a Covid lockdown period (about 80 consecutive days)

 

[neuro0101man]

I'm new here, but I've been using Excel and VBA for many decades. so here is my thought:

there is no way that any coding language is going to have the span length of the COVID pandemic in it's arsenal. however, VBA has many date functions. the primary one to get the difference between two dates is DATEDIFF(arg, arg, arg, arg). I think there are 4 arguments in there. by default, I believe, that function includes weekend days.

 

[sandy666]

maybe (as mentioned above but as worksheet function):

Book1
	B	C	D
2	01/01/2020		133
3	01/08/2020
Sheet1

Cell Formulas
Range	Formula
D2	D2	=DATEDIF(B2,B3,"d")-80

or

Book1
	A	B
2		01/01/2020
3		01/08/2020
4
5	covid	01/02/2020
6		20/04/2020
7
8	result	134
Sheet1

Cell Formulas
Range	Formula
B8	B8	=DATEDIF(B2,B3,"d")-DATEDIF(B5,B6,"d")

 

[sandy666]

or without DATEDIF()
=(B3-B2)-(B6-B5)

 

[FormR]

I am wanting to know the difference between two dates, including weekends but excluding a Covid lockdown period (about 80 consecutive days)

Hi, here is another option:

=NETWORKDAYS.INTL(A2,B2,"0000000",holidays)

Where holidays is a list of dates to exclude,