# Calculating number of working days between two dates

## Here is a simple, small formula for finding working days between two days (i.e. days excluding holidays and weekends.)

This Content Component encountered an error

A simple small formula for finding working days between two days (i.e. days excluding holidays and weekends.)

Steps followed:

1) Holidays are populated from a view named holidays;

2) date range arrived by exploding;

3) Holidays in the date range replaced with null value , resulting in all days in the range except the holidays;

4) Next step is to remove all weekends ;using @weekdays and removing 1's and 7's(sun=1 and sat=7)
*FROM and TO are two date fields*

```FIELD holidays:=@Dbcolumn("":"NoCache";"";"Holidays";1); FIELD dateRange:=@Explode(@TextToTime(@Text(FROM)+"-"+@Text(TO))); FIELD wkgDaysWithWE:=@Weekday(@TextToTime(@Trim(@Replace(dateRange;holidays;NULL)))); @Elements(@Trim(@Replace(@Text(wkgDaysWithWE);"1":"7";NULL))); OR use this one liner ;-) @Elements(@Trim(@Replace(@Text(@Weekday(@TextToTime(@Trim(@Replace(date
Range;holidays;NULL)))));"1":"7";NULL)));
```
This was last published in June 2002

#### Join the conversation

Send me notifications when other members comment.
FIELD holidays:=@Dbcolumn("":"NoCache";"";"Holidays";1);
FIELD dateRange:=@Explode(@TextToTime(@Text(Start)+"-"+@Text(End)));
FIELD wkgDaysWithWE:=
@Weekday(@TextToTime(@Trim(@Replace(dateRange;"";NULL))));
@Elements(@Trim(@Replace(@Text(wkgDaysWithWE);"1":"7";NULL)));

finalDateList:="";
@Transform( dateRange ; "variableName" ;

finalDateList := finalDateList + @If( @Weekday(@TextToTime(@Trim(variableName)))=1:7 ; "" ;

@If( finalDateList = "" ; "" ; ",") + variableName )

);
finalDateList;
Cancel
The Formula above provides the actual list of dates minus weekend and holiday dates.
Cancel

## SearchWindowsServer

• ### Future of Windows might involve significant weight loss

The influence of containerized applications could sway Microsoft to introduce more far-reaching refinements to Windows Server and...

IT workers need to learn how to ride the wave of innovation and master these five technologies related to Windows Server that can...

• ### Options for server management tools expand to meet IT needs

Not only do admins have to contend with a mix of server OSes, there are diverse scenarios to complicate their management. Learn ...

## 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 ...

## SearchDataCenter

• ### IBM Power9 servers seek market inroads to AI, cloud

IBM follows up its first Power9 server with a raft of systems designed to appeal to a wider array of markets -- most notably, AI ...

• ### Evaluate read-intensive and write-intensive SSD use cases

Consider write wear, performance and other factors when choosing between read-intensive, write-intensive and mixed-use ...

• ### Some hyper-converged infrastructure use cases pose pitfalls

Hyper-converged infrastructure adoption is skyrocketing, but that doesn't mean that the technology is the best choice for every ...

## SearchExchange

Everyone wants a smooth patching process, but things can fall apart despite everyone's best efforts. Develop a solid recovery ...

• ### New Office 365 administrators grapple with challenges

More enterprises mulling the move to Office 365 should factor in the adjustments necessary to get the IT department up to speed ...

• ### Curb stress from Exchange Server updates with these pointers

Some administrators let the memories of a bad patch linger and put off Exchange updates. Here are some tips to make this ...

## SearchContentManagement

• ### Content management in the cloud a main theme in 2018

The future of content management resides in the cloud and with AI, as several 2018 conferences will assure you.

• ### Six things to know about today's SharePoint implementations

As companies migrate their on-premises Microsoft SharePoint sites to the cloud, here are some things they should know about the ...

• ### Upgrades for the SharePoint Online portal

As more organizations migrate SharePoint sites to the cloud, Microsoft has increased at-a-glance dashboard data and analytics to ...

Close