Counting Days between a set of days

[arocha118]

I'm trying to could the number of days between a set of days.
Example:
1/1/19 - 12/31/19.
I need to could the days between 6/1 & 11/31 and never mind the year. If the dates are 1/1/19 to 12/31/20 then I need it to count them.

 

[GR00007]

Begin	End	Difference
1/1/2019	12/31/2019	364

<tbody>
</tbody>

=B2 - A2

To be inclusive (counting begin and end in the count):

=(B2 - A2) +1

 

[arocha118]

Thank you,

I'm looking for a subset. I only want to count the days between June and November. The original range could be 1/1/19 -10/15/19 or something like 6/15/19 - 6/5
/20

 

[Demonsguile]

I'm trying to could the number of days between a set of days.
Example:
1/1/19 - 12/31/19.
I need to could the days between 6/1 & 11/31 and never mind the year. If the dates are 1/1/19 to 12/31/20 then I need it to count them.

There is a straightforward formula that you can use for that:
=Days(End Date, Start Date)

To use your example, it will return 730 days if your values are 1/1/19 and 12/31/20.

 

[arocha118]

But I only want it to count the days between June 1 and Nov 30.

 

[Demonsguile]

But I only want it to count the days between June 1 and Nov 30.

The same formula should work. For example:
A1 = 6/1/2019
A2 = 11/30/2019

=days(A2, A1)
This will result in 182.

 

[Mentor82]

Hi,
I've accidently suggested you the wrong worksheet function. Use the one below to count network days.
It's got three paramters of which first two are required: first one is startdate ex 01.01.2019 and the second parameter are enddate ex. 31.01.2019. Both has to be formated as dates. Those two parameters calculate days from Mon to Fri between dwo dates ( it skips Saturdays and Sundays). The third parameter is optional, and here you can assign range or array of addidional holidays which are with Mon-Fri between start/end date. Here's an example of code I created. Start date I pool from range A2, end date from range B2 and optionally range of additional holidays range C2:C5. If you do not want to add addigional holidays to calculation just skip this third parameter and place only two.

Sub NetWorkDays()
    Dim StartDate As Date
    Dim EndDate As Date
    Dim rng_holidays As Range
    Dim WorkDays&
    Dim arr()
    
    Set rng_holidays = ActiveSheet.Range("C2:C5") 'setting the range of additional holidays which are within Mon-Fri
    StartDate = Range("A2")
    EndDate = Range("B2")
    
    arr = rng_holidays
    'As third parameter you ca use either range of additional holidays (dates) or array that include records of holidays
    'WorkDays=Application.WorksheetFunction.NetworkDays(StartDate, EndDate, rng_holidays)
    WorkDays = Application.WorksheetFunction.NetWorkDays(StartDate, EndDate, arr)
    ActiveSheet.Range("D2") = rng_holidays
    
    Set rng_holidays = Nothing
    
End Sub