Skip to Content
Former Member
Jan 23, 2014 at 08:57 AM

How to find the count of holidays between two dates( Start date and end date)


Hi All,

i have one requirement in my report. i have one prompt that contains number of days

based on number days we are suppressing the records the formula in my report is

(Today - {?Days}) - Date({OrderCrDate}) < 0 if the condition is true that record is suppressed.

order created date is coming from data base.

my requirement is to find out the number of weekends and holidays(business holidays)

for example

today is 01/23/2014

and i entered number of days 22

today-22 it will give 01/01/2014

from 01/01/2014 to Today(01/23/2014) we need to calculate number weekends and holidays

for holidays list we are maintaining excel file

we should compare the holidays exists between from date i mean 01/01/2014 to 01/23/2014 and count the exists dates.

if any body know the solution to solve the issue. Please help me out ASAP.