LinkBack URL
About LinkBacks
Hello, I have a list of dates in col "A". In col "B" i would like it to display the week it falls on. Example 12/12/08 would fall under week 12/7/08 to 12/13/08. Any ideas? Thanks
Hello, I have a list of dates in col "A". In col "B" i would like it to display the week it falls on. Example 12/12/08 would fall under week 12/7/08 to 12/13/08. Any ideas? Thanks
Last edited by Khaos176; 12-12-2008 at 03:36 PM.
Maybe you could use VLOOKUP & WEEKNUM. Create a table of the dates with the corresponding week number
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
The Sunday in the week of A1 is = A1 - WEEKDAY(A1 - 6, 3)
The Saturday in the week of A1 is = A1 + 6 - WEEKDAY(A1 - 6, 3)
Entia non sunt multiplicanda sine necessitate
Thank you both for your help. I looked into the ideas and still cant come up with anything. I am attaching an example to maybe help. Thanks again
In B2 and copy down, =TEXT(A2 - WEEKDAY(A2 - 6, 3), "mm/dd/yy to ") & TEXT(A2 + 6 - WEEKDAY(A2 - 6, 3), "mm/dd/yy")
Using your posted workbook, try this:
Copy that formula down as far as you need.
Please Login or Register to view this content.
Does that help?
Got it!!
Thank You.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks