Jump to content

Exclude weekends from number of days between dates?


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

Recommended Posts

Does anyone have an elegant and efficient calculation for getting the number of days between two days EXCLUDING weekends? I have an old calculation that I used way back in the FM3-FM6 era, but I imagine there is a much better, efficient calculation out there.

Link to comment
Share on other sites

  • Newbies

Hello

Is there a topic, or any reference here about date filters and agorithms?

The question above (excluding weekends) is related with date samplers. As far as I know, date filters or algorithms are typically used for obtaining the required time series variations in fee and commission calculations like:

  • month-end data
  • quarterly month-end averages
  • monthly data with maximum value of the month
  • quarter-end data with search-backwards method if the last day of quarter is not available

I have no idea how one could implement date filters and algorithms with filemaker. Anyway, I am planning to write an article about the mathematics of this issue. Any comments or quations are very much appreciated, so that I can consider them in my article.

See:

http://finaquant.com/forum/general-framework-concepts/article-about-date-filters-or-algorithms-for-fee-and-commission-calculations

Regards

Tunc

Link to comment
Share on other sites

This topic is 4239 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
×
×
  • Create New...

Important Information

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