
1. Re: Formula to calculate salary pay
philmodjunk Jul 14, 2015 2:31 PM (in response to blambert3)Please describe the following:
Please describe in general terms how this calculation is supposed to work to compute salary pay.
What does "NetworkDays" return? Need to know how that works and then look at how your data is set up in Filemaker in order to replicate its results.
What do the cells w2, x2, u2 and s2 store? How is this data stored in your FileMaker tables?
What is the significance of the hard coded dates 8/14/2015 and 8/13/2016? Does this define your fiscal year?

2. Re: Formula to calculate salary pay
TKnTexas Jul 14, 2015 2:36 PM (in response to blambert3)Have you created fields that correspond to the column headings that you have in Excel, i.e. W2=StartDate, X2=EndDate? Where you have a hardcoded date (8/14/14) those should be field names. I am not sure what U2 and S2 relate to, but they would need to be fields defined.
You will also need the Custom Function, listed on Brian Dunning's site
http://www.briandunning.com/cf/1182 
3. Re: Formula to calculate salary pay
blambert3 Jul 14, 2015 2:59 PM (in response to blambert3)The formula and fields would be like this:
==NETWORKDAYS(Start_Date,End_date)/NETWORKDAYS(DATE(2015,8,14),DATE(2016,8,13))*12*Monthly_Salary*Percent%

4. Re: Formula to calculate salary pay
philmodjunk Jul 14, 2015 3:10 PM (in response to blambert3)Which still fails to answer the rest of my questions. What does "NetworkDays" return?

5. Re: Formula to calculate salary pay
blambert3 Jul 17, 2015 9:33 AM (in response to blambert3)The network days are the amount of working days between their appointment/work time (start date and end date) excluding weekends. In the formula its the network days of their working appointment divided by the number of working days throughout the fiscal year.

6. Re: Formula to calculate salary pay
philmodjunk Jul 17, 2015 10:12 AM (in response to blambert3)Do you only need to exclude weekends? Don't need to allow for other days of not working in that time?
If so, then there is a knowledgeBase article that shows how to compute the number of weekdays between two dates. You can click the knowledgebase link above and search this one out to see how you might set up that calculation.