Creating a formula that extracts the week from a date

[moot]

Hi everyone, I have a very time consuming problem, I'm hoping someone will be able to help me with. Basically I have every single date from today until June 2015 in one column of an excel doc. In the next column, I have the week it resides it. Is there a formula that can be made to easily associate a date with a week? I've been doing this by hand, and it's taking a ton of time!

Thanks!


Date | Week
7/1/2012| 7/1/2012
7/2/2012 | .
. .
.
.
.
7/7/2012 | 7/1/2012

[Russell Dawson]

Hi moot - welcome to the forum.

You could go for week numbers with this in B1 when first date is in A1

Please Login or Register  to view this content.

and then B2

Please Login or Register  to view this content.

(copy down)

or for the first day of the week

in B1 put

Please Login or Register  to view this content.

and in B2

Please Login or Register  to view this content.

copy down

Hope this saves you time.

Cheers

[Cutter]

Assuming your dates are starting in A1

In B1: =A1
In B2: =B1 and drag down to B7

Now select: B1:B7 and double click on the drag handle