+ Reply to Thread
Results 1 to 4 of 4

Automatically Roll Date up to Start of Next Pay Period (Bi-weekly Pay Periods)

  1. #1
    Registered User
    Join Date
    04-16-2014
    Location
    Washington, DC
    MS-Off Ver
    Excel 2010
    Posts
    22

    Automatically Roll Date up to Start of Next Pay Period (Bi-weekly Pay Periods)

    Hello, am trying to think of a way that if I have a date entered in one column, if there's a formula that can reference that date, and populate a date in another column that reflects the date of the start of the following pay period? For example:

    A1 = 02/10/15
    A2 = 02/23/15 (the start of a new pay period).

    The pay periods are bi-weekly - so every other Monday new employees come on board. I'm trying to figure out if there's a way bo build in an established sequence no matter what date gets put in A1.

    Thanks! Chris

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Automatically Roll Date up to Start of Next Pay Period (Bi-weekly Pay Periods)

    Maybe =A1+14

    If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,695

    Re: Automatically Roll Date up to Start of Next Pay Period (Bi-weekly Pay Periods)

    With any date in A1 you can use this formula to get the next pay period start date

    =A1+MOD(DATE(2015,2,23)-A1,14)

    The date in the formula can be the start date of any pay period (past or future) so you don't have to change it unless your system changes

    If A1 is a start date itself then the formula returns the same date
    Audere est facere

  4. #4
    Registered User
    Join Date
    04-16-2014
    Location
    Washington, DC
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Automatically Roll Date up to Start of Next Pay Period (Bi-weekly Pay Periods)

    wished to thank you both-the solution proposed by daddylonglegs worked perfectly!! I was getting the #VALUE! issue, but altered the formula to take care of that and all is good! Thank you again - Chris

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help! Automatically roll out a series of date by adjusting the duration
    By cli881231 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-15-2015, 03:58 PM
  2. Replies: 2
    Last Post: 05-21-2014, 02:26 PM
  3. How to automatically increment periods by one month with different start dates
    By ohlalayeah in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-03-2013, 03:02 AM
  4. Automatically charting data on a weekly basis for a rolling 12 month period
    By xforum142riidax in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-15-2011, 11:05 AM
  5. Replies: 7
    Last Post: 11-16-2008, 05:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1