Forum Discussion
Determine if there are 78 or 79 pay periods in 36 months
Thanks for taking a look. My retirement plan determines what an individual's monthly retirement benefit is based on the pay for the highest 36 months before the retirement date. For most of us th...
Hi ajl_mo
the formula may need tweaking slightly but having a table listing all 14 day pay dates then will allow you to count how many pay dates fall between a specific day and 36 months prior to that day (calculated using the End Of Month function)
File attached..
Wyn
MVP