Hi,
I am drafting a spreadsheet where in one column I have a set of dates (Jan. 01 through Dec. 31) through a given year and in an adjacent column I would like for it to display the week of the year.
For example, if I enter a date between Jan. 01 through Jan. 07 then the column next to it will return a value of "01" for the first week of the year. It should be able to do this for any date range and match up the corresponding week of the year.
Thanks.
Hi seanpod
try
B5 being the cell value that contains the date.Formula:
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Oops sorry, that is going to return the week no in the year...Is this what you looking for...
If you always want Jan 1 to Jan 7 to be week 1 (regardless of day of week) then you can calculate based on the number of days so far in the year, e.g. with date in A2 use this formula in B2
="WEEK "&TEXT(INT((A2-DATE(YEAR(A2),1,1))/7)+1,"00")
Audere est facere
Both responses are precisely what I am looking for, though =weeknum is a much easier version.
Thanks to both of you
Cool. Please mark thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks