Requesting formula help for dates/years

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I am not sure how to go about this. I would like to use the calender or
dates to display the result.

For example, we are using 26 pay periods in the year. If 2004-02-10 falls
within period 03/2004 this year, how do I write a formula that determines
which period 2005-02-10 falls under the next year?

Thanks for any help.
Mark
 
Mark,

What are the rules for the period, for instance is 2004-02-09 in period 03
or 02?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find That Date 1
Calculating Pay Periods 4
Formula Help: Monthly Statistics 2
Date Calculation - Continuation 3
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Compare shorter date range against longer date range 2
cladding, cover gpago 1
pull data from one table to another if multiple conditions are met 3

Back
Top