Payroll Calendar Calculation ??!! Help?

[InFeKtId]

Hello,

What im trying to do is create a Excel Form that will display the dates of our new hires raise points Per pay period. example:


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Employee Name[/TD]
[TD]HIRE DATE [/TD]
[TD]6 Months[/TD]
[TD]1 Year [/TD]
[TD]2 years [/TD]
[TD]3 Years[/TD]
[TD]6 Years [/TD]
[/TR]
[TR]
[TD]Test Testington[/TD]
[TD] 8/4/2014[/TD]
[TD]Date here[/TD]
[TD] Date here[/TD]
[TD]Date here[/TD]
[TD]Date here[/TD]
[TD]Date here[/TD]
[/TR]
</tbody>[/TABLE]

I need it to land on every friday bi weekly for each pay period avoiding landing on weekends and holidays of course.

I think I have the first part kind of heading in the right direction, but i'm not very good with this date thing on excel. I'm alright with the simple stuff but this is OMH?

This is what I have so far .... no much.... =$B2-WEEKDAY($B2)+13 this seems to be landing on Fridays and no matter what the start date is its landing on the next bi weekly pay period. It seems to be picking the right ones from what I tested but you guys are the experts


Thanks in advance
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[konew1]

The formula as proposed will be ok. I think you have missed out the $ signs that lock the reference to A3 when you copy.
A6+14-MOD(A6-$A$3,14)