Thanks:  0
Likes:  0

# Thread: Formula for counting weeks /year

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

Hope that the above is clear enough...

//D

2. hi - welcome to the board!

what is the maximum length of a course, in weeks.

3. ## Re: Formula for counting weeks /year

assuming that course doesn't span more than 1 year, see if this helps at all:

******** ******************** ************************************************************************>
 Microsoft Excel - Book2 ___Running: xl2000 : OS = Windows 98
 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
 C2D2E2F2C3D3E3F3C4D4E4F4C5D5E5F5C6D6E6F6C7D7E7F7 =

A
B
C
D
E
F
1
StartEndCourse Length in weeksSpan a year?Year 1 WeeksYear 2 Weeks
2
1/10/001/3/0121 Weeks 4 DaysTRUE13.008.43
3
1/3/011/6/0113 Weeks 1 DaysFALSE13.14
4
1/5/011/9/0117 Weeks 4 DaysFALSE17.57
5
1/7/011/12/0121 Weeks 6 DaysFALSE21.86
6
1/9/011/3/0225 Weeks 6 DaysTRUE17.298.43
7
1/11/011/6/0230 Weeks 2 DaysTRUE8.5721.57
 Sheet1

[HtmlMaker 2.20] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

the split calcs aren't exactly accurate, but should get you started.

4. ## 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.

//Dagge

5. ## Re: Formula for counting weeks /year

try this site...I think Dennis has a formula translator,

http://www.xldennis.com/

if not Ivan has,

6. ## Re: Formula for counting weeks /year

dagge,
if you want I'll type it in a sheet and send it ...
it will translate on its way

regards,
Erik

7. erik!
Yes please, that would be great!

//D

8. ## Re: Formula for counting weeks /year

so send me an email that I can reply
(leaving now for some 5 hours)

regards,
Erik

9. ## Re: Formula for counting weeks /year

Erik!

Got your file, but it didn't work

Mailed you, and I hope you can give me a solution!

//D

10. ## Re: Formula for counting weeks /year

Dagge,

you have &YEAR
it must be & YEAR with a space !

perhaps Excel is making the error when translating from dutch to swedish ?
so I changed it but it's possible that you'll have to do it again yourself

kind regards,
Erik

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.