PC Review


Reply
Thread Tools Rate Thread

Calculate the Pay Period from the date

 
 
Guest
Posts: n/a
 
      1st Oct 2004
Hi folks, I'm trying to calculate the pay period for any
date. Right now I can calculate it by taking the
difference from a reference date. However, this limits
me to dates that occur after the reference date. I'm
hoping someone can show me a more general formula that
will work for any date entered. The formula I am using
now is:
=mod(int(B5-37968)/14,26)+1
Were B5 is the date I'm calculating the Pay Period for,
and 37968 is the reference date. The pay periods are two
weeks long, with 26 pay periods in the year.
To make it more interesting the Pay Periods don't start
at the begining of the year. For FY 2004 it started on
12/25/2003, in FY 2005 it will start on 12/24/2004.

Thanks
Mike
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate a date based on period and year =?Utf-8?B?U2Ft?= Microsoft Excel Worksheet Functions 5 27th Aug 2007 07:11 AM
How to calculate period manan Microsoft Excel Discussion 3 12th May 2006 03:00 PM
how to calculate mean production for a period John Smith Microsoft Access 0 12th Jul 2004 03:04 PM
How to calculate a period of time AmandaP Microsoft Access Queries 2 27th May 2004 12:39 PM
Calculate rolling 12 mo period Leah Microsoft Access VBA Modules 2 18th Jul 2003 03:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:38 PM.