+ Reply to Thread
Results 1 to 5 of 5

Bi-weekly pay period

Hybrid View

Luigi802 Bi-weekly pay period 07-13-2016, 06:10 PM
Phuocam Re: Bi-weekly pay period 07-13-2016, 07:14 PM
Luigi802 Re: Bi-weekly pay period 07-13-2016, 07:29 PM
Phuocam Re: Bi-weekly pay period 07-13-2016, 08:04 PM
Luigi802 Re: Bi-weekly pay period 07-13-2016, 08:29 PM
  1. 07-13-2016, 08:04 PM #1
    Phuocam is offline
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2024
    Posts
    6,175

    Re: Bi-weekly pay period

    ...

    =CEILING(N3,28)+20
    Reply With QuoteRegister To Reply
  2. 07-13-2016, 08:29 PM #2
    Luigi802 is offline
    Registered User
    Join Date
    10-11-2014
    Location
    Noitacol, Acirema
    MS-Off Ver
    Office 365 2019
    Posts
    53

    Re: Bi-weekly pay period

    Quote Originally Posted by Phuocam View Post
    ...

    =CEILING(N3,28)+20
    Sweet, yes that works!! Thank you! I actually did come up with another formula "=LOOKUP(N3+31-DAY(N3+31),N3+MOD(DATE(2016,1,1)-N3,14)+{14,28})" But yours is SOOO much simpler!!
    Last edited by Luigi802; 07-13-2016 at 08:33 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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. How to sum when it exceeds limits and calculate the period (payback period)
    By jihyeu in forum Excel Formulas & Functions
    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. Excel 2007 : How to extract the period from a Year / Period text string
    By The_Snook in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1