Holidays Between Two Given Dates

Given two dates, this formula calculates the number of saturdays and sundays
between them.
StartingSaturDay:=@If(
@Weekday(StartDate) < 7; @Adjust(StartDate;0;0;(7-@Weekday(StartDate));0;0;0);
StartDate);

StartingSunday:=@If(
@Weekday(StartDate) > 1;@Adjust(StartDate;0;0;(8-@Weekday(StartDate));0;0;0);
StartDate);

EndingSaturDay:=@If(
@Weekday(EndDate) < 7;@Adjust(EndDate;0;0;-(@Weekday(EndDate));0;0;0);
EndDate);

EndingSunday:=@If(
@Weekday(EndDate) > 1;@Adjust(EndDate;0;0;-(@Weekday(EndDate) - 1);0;0;0);
EndDate);

TotCount:=((((EndingSaturDay - StartingSaturDay)/86400)/7) + 1) +
((((EndingSunday - StartingSunday)/86400)/7) + 1);
@Prompt([OK];"Holidays";@Text(TotCount));
This was first published in November 2000

Dig deeper on Domino Resources - Part 6

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchWinIT

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchVirtualDataCentre.co.UK

Close