Calculating Periods

[rplum80]

Hey Guys!

I don't know enough of Access to figure this one out. I am trying to calculate Periods in a calendar year through a query. Basically we have 13 periods in a year, here is the breakdown starting from January 1st 2016.

Weeks 1 - 4 = Period 1
Weeks 5 - 8 = Period 2
Weeks 9 - 12 = Period 3
Weeks 13 - 16 = Period 4
Weeks 17 - 20 = Period 5

etc.

Is there a formula that would calculate this?


Thanks again.

 

[sneuberg]

What do you want to calculate? What are the inputs and outputs? For example do you want something that when given a period (a number) would give you the start date or the end date of that period?

 

[rplum80]

What do you want to calculate? What are the inputs and outputs? For example do you want something that when given a period (a number) would give you the start date or the end date of that period?

Sorry should have been more specific. If between January 1st and January 30th, then the period = 1. If between January 31st and February 27th, then the period = 2. etc

Something similar to the attached. (ignore Colleague_number) column.

 

[sneuberg]

Those periods don't make sense to me. The first has 30 days and starts on a Friday and ends on a Saturday. The second has 28 days and starts on a Sunday and ends on a Saturday. What are the rules and it still is not clear what the inputs and outputs to the calculation should be. Is a date the input and the period the output? Or week number the inputs and period the output? Period number as input and start week as output?

How is this formula going to be used? Maybe that would help me understand what you want.

 

[plog]

You need to step away from posting and really think about what you want to accomplish. Your second post isn't logically consistent with your first, and then your image makes it even more confusing.

At first every 4 weeks was a period (although you didn't define when weeks start). Then your define periods to not be exact weeks. Then you posted an image that overlooked Week 5.

If you want to divide time up into 13 periods you really need to have a rock solid definition of what a period is. It is going to be hard, mainly because 13 is a horrible number to use as a time divisor. Weeks are 7 days, there are about 52.1/52.3 weeks in a year, there are 12 months in a year and there are 365/366 days in a year. None of those numbers(7, 12, 52.1, 52.3, 365, 366) are divisible by 13.

 

[rplum80]

You need to step away from posting and really think about what you want to accomplish. Your second post isn't logically consistent with your first, and then your image makes it even more confusing.

At first every 4 weeks was a period (although you didn't define when weeks start). Then your define periods to not be exact weeks. Then you posted an image that overlooked Week 5.

If you want to divide time up into 13 periods you really need to have a rock solid definition of what a period is. It is going to be hard, mainly because 13 is a horrible number to use as a time divisor. Weeks are 7 days, there are about 52.1/52.3 weeks in a year, there are 12 months in a year and there are 365/366 days in a year. None of those numbers(7, 12, 52.1, 52.3, 365, 366) are divisible by 13.

No need. Figured it out.

Thanks