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.