6 Replies Latest reply on Jul 17, 2015 10:12 AM by philmodjunk

# Formula to calculate salary pay

### Title

Formula to calculate salary pay

### Post

I am trying to take an excel formula:

=NETWORKDAYS(W2,X2)/NETWORKDAYS(DATE(2015,8,14),DATE(2016,8,13))*12*U2*S2

and transfer it to filemaker to calculate Gross salary. How do I take this formula and recreate it within FileMaker?

• ###### 1. Re: Formula to calculate salary pay

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

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
http://www.briandunning.com/cf/1182

• ###### 3. Re: Formula to calculate salary pay

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

Which still fails to answer the rest of my questions. What does "NetworkDays" return?

• ###### 5. Re: Formula to calculate salary pay

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

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.