subtract x number of work days from date

[Devin]

I'm needing a calculation that will subtract x number of work days from date.

"x" will be a variable number

I've used this calc before but I'm not able to get it to work as I need to subtract working days.

http://help.filemaker.com/app/answers/detail/a_id/3926/~/calculating-a-finish-date-given-a-starting-date-and-the-number-of-work-days

Thanks

[webko]

Doesn't the 'extra' section at the bottom of that link address this? Cast your number to a negative to subtract...

[comment]

1 hour ago, webko said:

Cast your number to a negative to subtract...

Just to clarify: you need to use a different lookup array for subtractions - IOW, use the formula at the bottom of the linked page, not the one at the top.

 

@Devin

See a different method (one that actually calculates, instead of looking up pre-calculated values) here:
http://fmforums.com/forums/topic/34344-add-or-subtract-working-days/#comment-159334

Note that here too the formula for subtracting is different from the formula for adding.

 

Edited May 13, 2016 by comment