Calculate Finace Periods from the given Date

P

Pat

Our fiance periods run 4 week, 4 week, 5 week per quarter. I need to be able
to determine which period a given date falls in. I have looked around, but I
have not been able to find a solution.

I would like to create a function that would return an integer indicating
the period.

Any help is appreciated.
 
O

orange via AccessMonster.com

Pat said:
Our fiance periods run 4 week, 4 week, 5 week per quarter. I need to be able
to determine which period a given date falls in. I have looked around, but I
have not been able to find a solution.

I would like to create a function that would return an integer indicating
the period.

Any help is appreciated.
Click to expand...

When does your financial year start?
What integer would you return for activity Mar 4/2010? Jan 28/2010?
 

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

Week 53 and Week 1 from a given date 2
Sum of Numbers of a Rolling 6 month Period range 0
Calculating percentage growth rate from a cumulative figure 4
XIRR vs. IRR Function 11
After Update: Pay Period Date 1
Problem with dates in a Gannt chart - please help 0
calculating number of prior pay periods in year when given specificdate. 1
Spreadsheet to total weeks up to 52 1

Top