Pay Date based on date

[STEVEMILLS04]

Thank you in advance for ANY help! I need to create a list of dates from 2006 thru 2013 in column A, then to have the paydate in column B. Obviously, doing this manually would take forever! I already have the dates listed in Column A, just need to figure out a formula to calculate the pay date in B. Our pay periods are biweekly, and run Sunday thru Saturday. For example, Pay date 01/27/2012 is for pay period 01/01/2012 - 01/14/2012. My list needs to be as follows:



Date Pay Date
01/12/2012 01/27/2012
01/13/2012 01/27/2012
01/14/2012 01/27/2012
01/15/2012 02/10/2012

and so on, from 2006 thru 2013. Thanks again!

 

[jasonb75]

Enter the date 01/01/2006 in say A1, then use the fill handle to copy it down to around A3000, the date should auto increase.

Then in A2 enter

=CEILING(A1,14)+13

and double click the fill handle to copy the formula down next to the dates.

It matches with your sample dates, however, please note that it might not work if you use the 1904 date system.

 

[STEVEMILLS04]

W0ow, worked exactly as needed. Thanks so much!