Removing Weekends from a Calculated Formula

[BradL]

Hi,

I've created a few custom date fields. I want to subtract
a fixed quantity of days from one of these dates but I
want the calculation to exclude weekends.

Any ideas????

Thanks,
Brad

 

[Gérard Ducouret]

Hello Brad,

Try the ProjDateSub( date; duration; calendar ) function.

Gérard Ducouret

Excerpt of the Help :
Returns the date that precedes another date by a specified duration.

Syntax

ProjDateSub( date, duration, calendar )

date Required; Variant. The original date from which duration is
subtracted.

duration Required; Variant. The duration to subtract from date.

calendar Optional; String. The calendar to use when calculating the date
difference. If calendar is not specified, the default for the current
resource is the resource calendar, or for the current task, the task
calendar or the standard calendar if there is no task calendar.

 

[BradL]

Thanks Gerard, I'll give it a go. Appreciate your help!