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
Last edited by moot; 07-02-2012 at 12:14 AM.
Hi moot - welcome to the forum.
You could go for week numbers with this in B1 when first date is in A1
and then B2
=WEEKNUM(A1)
(copy down)=IF(WEEKNUM(A2)=WEEKNUM(A1),"",WEEKNUM(A2))
or for the first day of the week
in B1 put
and in B2=A1-WEEKDAY(A1)+1
copy down=IF(A2-WEEKDAY(A2)+1=(A1-WEEKDAY(A1)+1),"",A2-WEEKDAY(A2)+1)
Hope this saves you time.
Cheers
Last edited by Russell Dawson; 07-02-2012 at 04:31 AM. Reason: NOTE TO MOD - POSTED AFTER CHANGE BY OP
If I helped, please don't forget to add to my reputation. (click on the star below the post)
If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.
Failure is not falling down but refusing to get up.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks