Hi,
I am wondering if anyone knows a formula that will return the first
date of the next bi-weekly "Sunday to Saturday" payroll period after
a given date.
For example, the 2016 first bi-weekly payroll period runs from
1/3/2016 to 1/16/2016, the second runs from 1/17/2016 to 1/30/2016,
and so on. If I have a date in cell A1 of 8/10/2016, does anyone have
a formula that will return the first date of the next bi-weekly pay
period, 8/14/2016?
Thanks in advance of your response!
Have a look here for *PatPeriodTables.xls*...
https://app.box.com/s/23yqum8auvzx17h04u4f
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus