Feature Proposal: Add ADDWORKINGDAYS to SpreadSheetPlugin

Motivation

We have a WORKINGDAYS that calculates the number of working days between two dates.

And that is cool. But often you have a date and want to calculate a date in the future based on number of working days.

I have the algo from the new TimeCalcPlugin. What I plan to add is the western simple version that assumed Saturday/Sunday weekends.

The TimeCalcPlugin is a pure registered tag plugin and though powerful, it has its limitations. The SSP has all the spreadsheet features so we also need the function there.

Description and Documentation

It is the algo from _ADDWORKINGDAYS I will add with syntax

$ADDWORKINGDAYS(date, days)

I will consider holidays also for both WORKINGDAYS and ADDWORKINGDAYS but may not be in first round.

The change will be fully backwards compatible with current SSP and the number of new code lines is 15 or so.

Examples

Impact

Implementation

-- Contributors: KennethLavrsen - 24 Nov 2010

Discussion

Since the 1.1.3 planned release has already gone, I have removed the planned release to allow Kenneth to re-plan.

-- CrawfordCurrie - 24 Feb 2012