Formula to calculate holidays

D

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
2,352
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
I have a formula to calculate the number of holidays between 2 dates but it isn't working.

This is the formula
VBA Code: 
=SUMPRODUCT((Sheet2!G87:DO97>=H6)*(Sheet2!G87:DO97<=J6))

  • Start date is in H6
  • the end date is in J6
  • range of holidays is in Sheet2!G87:DO97
What is wrong with this formula?
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Sort by date Sort by votes
You're formula looks right. Are all the dates actual Excel dates are could some are all of them be text?
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Solved
Projecting End date by accounting for holidays
Replies
4
Views
269
BB77
B
J
  • Solved
Calculating the standard deviation of two weighted arrays.
Replies
5
Views
386
StephenCrump
S
E
  • Solved
Unexpected flaw in WORKDAY formula to calculate date
Replies
7
Views
336
KRice
K
Data123
  • Solved
Holiday Dates=Sorting Issue
2
Replies
18
Views
445
Alex Blakenburg
A
A
  • Solved
NETWORKDAYS vs COUNTIFS
Replies
2
Views
164
amberd
A

Forum statistics

Threads
1,214,788
Messages
6,121,582
Members
449,039
Latest member
Arbind kumar

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top