Jump to content

subtract x number of work days from date


This topic is 2234 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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 by comment
Link to comment
Share on other sites

This topic is 2234 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.