Answer:
Extra Information -
I have an excel problem and I need a formula to perform the task. Here is the situation: I have two tables in excel; a table full of dates and a table showing the week numbers. I have been given some dates in this format "28/01/2010". I need excel to work out which week number (in the year) this date falls into and then put a "1" in that week row.
For example: if I get given the date "28/01/2010", excel will look at that date and put a "1" in the week 4 row because that date is found in week 4 of the year. If then I get given another date: "25/01/2010", excel will add another 1 to the week 4 row, meaning week 4 row will display "2". All together, I have been given lots of different dates and I want excel to sort all the dates into their corresponding week numbers within the year. This is ultimately to create an automatic system where the dates can be typed into a excel table, and then they can be turned into week number type form in the other table.
I hope this is clear enough. :)