# Weekly Reports

1. ## Weekly Reports

Hi, in need of some help....

i need to develop a rule in which will calculate the which week of the month it is based upon todays date.

If anyone could help me with this that would be greatly appreciated.

2. ## Re: Weekly Reports

Hi,

can you describe the "rules" you want to apply in plain English? Take this month for example. 3-Aug is a Monday. Is that week 1 or week 2?

3. ## Re: Weekly Reports

in plain English
thats rich considering your respective locations

4. ## Re: Weekly Reports

LOL, you're right, the Ozzies can't do plain English, and I have a German accent.

5. ## Re: Weekly Reports

Batman, please clarify, when does week 2 start:

- on the 8th day of the month? or
- on the first Monday after the 1st of the month?

6. ## Re: Weekly Reports

week 1 being 3/8/09 - 7/8/09
week 2 being 10/8/09 - 15/8/09
etc...

i want the rule to realise if date falls between 3/8 and 7/8 it will go to sheet 2 if it falls between 10/8 and 15/8 goes go shet 3... hopefully makes a little more sense now??

7. ## Re: Weekly Reports

no, sorry, it does not make more sense.

if monday, 3-aug-09 is week 1, that means that Sat 1-aug-09 is the start of the week. Fine.

Given that a week has 7 days, week 2 would span from sat 8-aug-09 to fri 14-aug-09.

Sat 15-aug-09 would be week 3, but you want it in week 2. That does not gel.

8. ## Re: Weekly Reports

This formula

=INT(((DAY(A2))-WEEKDAY(A2,2)+7)/7)

will return a week number for the date in cell A2.

A new week count will start on a Monday. If the first week of the month does not include a Monday, that week will be week # 0 and the following Monday will be in week 1.

That's the best I could do. Maybe the formula gurus can come up with something more sophisticated.

All thunk out now.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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