Number of Pay Periods in a Fiscal Year

[homage]

If my fiscal year ends 12/31 but the pay period doesn't end until 1/10, how do I get a query to tell me there are 25.3 pay periods remaining (counting from the last pay period 1/11)?

 

[jdraw]

How do you define payPeriod?
When is the first payPerion in the year?

 

[homage]

Pay periods are every two weeks. The pay period started 12/29/2013 and ended 1/11/2014. The next one started 1/12/2014 and ends 1/25/2014. People generally work Mon-Fri or paid holiday so we just exclude Sat-Sun for planning purposes. At the end of 2014, the pay period is looked as 3 days in 2014 then 7 days in 2015. When we're planning for 2015, we can just plan for 26 full pay periods. It just gets tricky once the year has started.

I load salaries paid in Access with the pay period ending date and have a query that projects salaries for the rest of the year. Right now, I have a table that has all the 27 pay period dates of the year with the remaining number of pay periods. I have to update each record on that table every year. At the end of 2013, the last pay period only had 2 days in 2013. Someone I work with said there was probably a way for the system to calculate it but he wasn't sure how.

I'd like to load in salaries paid and have Access count how many 2-week periods until the end of the year from the latest pay period ending date and only consider Mon-Fri.

 

[homage]

I got the answer, where AsOf is the pay period that just paid

RemainPP: Round(((#12/31/2014#-[AsOf])/14),1)