Formula for counting weeks /year

[dagge]

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).


Hope that the above is clear enough...


//D

 

[dagge]

Thanks for the help guys!
It solved a huge part of the problem, but the formulas in cells L4 and N4 gets a negative result.
I use the following formula:
=OM(E9>1;OM(J9;(NETWORKDAYS(H9;--"2005-01-01"))/5;"");"")
I realise that the cell H9 is the "wrong" one. But I need to subtract the value in cell H9 (for example 2005-01-31) with the value "2005-01-01" to get the number of weeks.

Thanks for your help!

//dagge

 

[fairwinds]

Then you can swap the values in the NETWORKDAYS formula.

And as Aladin pointed out: you can omit the -- (two minuses)
in the formula.

 

[dagge]

Jupp!

I solved it just before your post with this formula: =OM(E9>1;OM(J9;-(NETWORKDAYS(H9;--"2005-01-01"))/5;"");"")

Thanks anyway!!

//D