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

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)));
```

### 2 comments

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

• ### Windows Server certifications retirement plan a blow to admins

This latest decision by Microsoft to drop the MCSA, MCSD and MCSE certifications is another step to push customers toward the ...

• ### Do you need to make Exchange Online backups?

Microsoft has several protective measures in place to let customers restore deleted mail in Office 365, but backup vendors will ...

• ### Updated Exchange Online PowerShell module adds reliability, speed

Microsoft assists Exchange Online administrators who rely on PowerShell by reworking the underlying functionality of several ...

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

• ### Build a migration plan for enterprise edge infrastructure

Micro data centers are essential to edge computing use cases. Build an effective migration plan through site selection, ...

• ### Tech giants aim supercomputers, clouds at finding a COVID-19 cure

The new COVID-19 HPC consortium comprised of tech giants, national labs and academia are using supercomputers and clouds to speed...

• ### Top vendor SDDC certification programs for admins

If you decide to grow your knowledge of software-defined data center technologies, VMware, Nuage Networks and Microsoft offer ...

## SearchContentManagement

• ### Creating digital experiences key to driving exceptional CX

The way in which businesses build digital experiences is ever-evolving. It's a race to create easier-to-use customer interfaces ...

• ### Vendors offer free remote work technology for telecommuting

It's more than a marketing ploy: Cloud technology vendors, seeing their own issues enabling remote work, extend paid products to ...

• ### How businesses should deal with enterprise search issues

Enterprise search issues frequently complicate user experience with ECM systems. While users may face many problems, they also ...

Close