Results 1 to 5 of 5

Bi-weekly pay period

Threaded View

  1. #1
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    Office 365 2019
    Posts
    53

    Bi-weekly pay period

    I'm trying to calculate the last bi-weekly pay day in any given month, for example this month my pay dates are as follows; 1 Jul 2016, 15 Jul 2016, and 29 Jul 2016. I want to automatically show the last payday of this month regardless on what day today is. I've been playing with this formula, but when I roll over to the next month it doesn't follow correctly

    =IF(MONTH(N3+28)-1=MONTH(DATE(2016,1,1)),EOMONTH(N3,0),N3+28)
    Where as "N3" is always the 1st day of the current month, this works fine until I change "N3" to any day in August, then it returns 29 Aug 2016 when it should show 26 Aug 2016 to continue the bi-weekly pay schedule
    Last edited by Luigi802; 07-13-2016 at 06:40 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Converting daily data into weekly and making the weekly number a cumulative return
    By Duchess1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-28-2015, 10:23 AM
  2. [SOLVED] Automatically Roll Date up to Start of Next Pay Period (Bi-weekly Pay Periods)
    By cmkarnes in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-21-2015, 11:23 AM
  3. [SOLVED] Count weekly occurences of a value within a time period
    By cs454 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-21-2014, 09:28 AM
  4. Replies: 1
    Last Post: 04-24-2013, 11:38 PM
  5. [SOLVED] Complicated:Calculate time period based on no. of units sold + fluctuations within period
    By omaha.crab in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2012, 03:04 AM
  6. Replies: 2
    Last Post: 08-06-2011, 11:15 AM
  7. 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

Tags for this Thread

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