Omitting Weekends from a Formula

[BradLev]

Hi

I'm trying to create a date formula that subtracts one custom date from another. But I would like it to omit weekends from the calculation.

 

[John Beamish]

ProjDateDiff( [start], [finish]) returns a result of 2 if the start date is
Friday and the Finish date is the following Monday. Is this what you mean?

JLB, PMP

Hi,

I'm trying to create a date formula that subtracts one custom date from

another. But I would like it to omit weekends from the calculation.

 

[JackD]

As another poster has noted, you can use projdatediff. It allows you to
specify a calendar to base the difference on. If you do not specify a
calendar then it uses the standard calendar. This way you can calculate
based only on working times or you can set a calendar up anyway you would
like.

Syntax is:

ProjDateDiff( date1, date2, calendar )

-JAck

Hi,

I'm trying to create a date formula that subtracts one custom date from

another. But I would like it to omit weekends from the calculation.