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.