• Status: Solved
• Priority: Medium
• Security: Public
• Views: 274

# How to write a formula in Excel that will calculate week number?

I've attached a sample workbook. Here is the breakdown.

Column C is the "Event Date" this is the date an event happened.
Column D is the "Followup Activity Date", These are the dates for all of the activity going forward for the "Event Date".
Column E or higher(not in the spreadsheet) would be data that relates to the "Followup Activity Date"

For example the "Event Date"  might be the day someone signed up for a class or even better  started a project. Column E might be what was accomplished and Column D would be the date it was accomplished.

In the workbook you will see two additional columns - A & B. In column A I calculated what number day it is for the entire date range for the Event Date in column C. This was not a problem. What I am stuck on is calculating the week number. The first 7 days will be week 1. The second seven days will be week 2 and so on until we reach the next Event Date which in this workbook would be 6/2/2011

What formula will work? Activity-Report.xlsx
0
futr_vision
• 2
1 Solution

Commented:
I don't see any attachment....

but if you have number of days in A2 the try this formula for week number in B2

=INT((A2+6)/7)

regards, barry
0

Commented:
....OK, now I see the attachment!

The formula I suggested should work for you, put in B2 and copy down.....

regards, barry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.