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?
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 hard-coded 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
The formula and fields would be like this:
Which still fails to answer the rest of my questions. What does "NetworkDays" return?
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.
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.