Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

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
Asked:
futr_vision
  • 2
1 Solution
 
barry houdiniCommented:
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
 
barry houdiniCommented:
....OK, now I see the attachment!

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

regards, barry
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now