Formula that will take me to the next pay period end date.

[wamley]

I'm trying to create a formula that will take me to the next pay period end date.

For example, if the employee's leave of absence is going to go unpaid effective 1-1-15, I want a formula that will tell me when the last day of the pay period is for 1-1-15. We have a biweekly pay periods. Setting up the biweekly payperiods is pretty easy, but I'm not sure how to go from there.

Hope that made sense. I'd appreciate any help.

Thank you!

 

[Momentman]

I'm trying to create a formula that will take me to the next pay period end date.

For example, if the employee's leave of absence is going to go unpaid effective 1-1-15, I want a formula that will tell me when the last day of the pay period is for 1-1-15. We have a biweekly pay periods. Setting up the biweekly payperiods is pretty easy, but I'm not sure how to go from there.

Hope that made sense. I'd appreciate any help.

Thank you!

Welcome to the forum

For the sample date provided, 1.e 01-01-2015, what would be the next pay period (Date)? so am sure i understand you

 

[wamley]

Welcome to the forum

For the sample date provided, 1.e 01-01-2015, what would be the next pay period (Date)? so am sure i understand you

the next pay period end date would be 1/3/15. The next pay period end date after that would be 1/17/15. Basically I want to enter a date and for it to tell me when the next pay period end date would be. Is that possible? Thank you.

 

[Crystalyzer]

you can use the formula in Cell B4 below:

=ROUNDUP((B3-B1)/B2,0)*B2+B1


[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Beginning Pay Period[/TD]
[TD]01/03/15[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Days Per Pay Period[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Date Entered[/TD]
[TD]02/05/15[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Next Pay Period End Date[/TD]
[TD]02/14/15[/TD]
[/TR]
</tbody>[/TABLE]