Formula for counting weeks /year

This is a discussion on Formula for counting weeks /year within the Excel Questions forums, part of the Question Forums category; Hello all!
Need some help with the following prob I've got.
I have an education that costs say $100/week for ...

Formula for counting weeks /year

Hello all!

Need some help with the following prob I've got.

I have an education that costs say $100/week for the students.
The education is 4-8 months, and starts when I have a full class.
So to calculate my budget I need to now how many weeks the education has been per year.
I.e. If one class starts on dec.1 year 2004, and ends jan.14 year 2005, then there has been 4 weeks for year 2004 (i.e. $400) and 2 weeks for year 2005 ($200).

Which formula do I use?
I know which formula I need to use just to count weeks, but how do I separate them every year (so to speak).

Re: Formula for counting weeks /year

YES!!!

This is exactly what I was looking for!
Only problem is that I can't get it to work in my sheet

I'm using Win98 and Excel'97, all swedish versions, could that be the problem?
I only get " #NAME? " in cell C2, column "Course length in weeks", and in cell E2 I get an error that complains on the refer D2.

The maximum length of a course shouldn't exceed the length of 1 year, but it may happen sometime in the future.