### 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?

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?