+ Reply to Thread
Results 1 to 2 of 2

How to calculate number of pay periods??

  1. #1
    Registered User
    Join Date
    10-03-2014
    Location
    Utah
    MS-Off Ver
    2007
    Posts
    42

    How to calculate number of pay periods??

    Let's say I have these two dates:

    4/5/2013
    1/9/2015

    I want to calculate how many bi-weekly pay periods there are between those two dates INCLUDING the first date, but NOT including the second date. So far I have used the good ol' count the days on the calendar, but now I have dates that are much earlier and thought it would be much more efficient to use a formula instead of counting manually.

    I haven't really used formulas for dates before, so I don't really know where to start. Any help is appreciated!!

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: How to calculate number of pay periods??

    The DATEDIF() function can help. The number of days between two dates:

    =DATEDIF(A1, A2, "d")

    The number of two-week periods:

    =DATEDIF(A1, A2, "d")/14
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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. What formula to calculate periods??
    By rowley1500 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2013, 04:54 AM
  2. Calculate BiWeekly Pay Periods
    By gjames in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-25-2013, 02:13 PM
  3. Calculate time periods before and after 7pm
    By Sukeany in forum Excel General
    Replies: 2
    Last Post: 10-22-2011, 07:24 PM
  4. Calculate time between three periods
    By adhide in forum Excel General
    Replies: 1
    Last Post: 03-14-2011, 11:00 PM
  5. calculate time periods
    By umba-sr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-21-2006, 10:13 AM
  6. [SOLVED] How do I calculate rate when pmt is made at end of periods
    By Ron Coderre in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 PM
  7. [SOLVED] How do I calculate rate when pmt is made at end of periods
    By hsummer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  8. [SOLVED] How do I calculate rate when pmt is made at end of periods
    By hsummer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM

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