Changing Week Range In Excel?

**ExcelExcel11** · 09-14-2011, 05:00 PM

I currently have a large file filled with dates and would like to make a column to show the number of the week that date was on. At the moment I am using the typical WEEKNUM formula. But, there is one thing I want to change. I know that at the moment WEEKNUM assumes that the week goes from Sunday - Saturday. I would like to change that so that the week goes from Saturday - Sunday. If anybody could tell me how to possibly do this that would be great.

Thanks.

**TMS** · 09-14-2011, 05:40 PM

From the Help:

Syntax

WEEKNUM(serial_num,return_type)

Serial_num is a date within the week. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

Return_type is a number that determines on which day the week begins. The default is 1.

Return_type Week Begins
1 Week begins on Sunday. Weekdays are numbered 1 through 7.
2 Week begins on Monday. Weekdays are numbered 1 through 7.

Regards

**ExcelExcel11** · 09-14-2011, 06:19 PM

Hi! Thanks for the response, I checked that out, but the only problem is that this only allows you to set the start of the week to monday. I was wondering if it was possible to set the start of the week to Saturday.

Thanks!