Page 1 of 3 123 LastLast
Results 1 to 10 of 23

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

  1. #1
    New Member dagge's Avatar
    Join Date
    Apr 2004
    Posts
    10

    Default 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. #2
    MrExcel MVP
    Join Date
    May 2002
    Posts
    13,993

    Default

    hi - welcome to the board!

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

  3. #3
    MrExcel MVP
    Join Date
    May 2002
    Posts
    13,993

    Default 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
    =

    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. #4
    New Member dagge's Avatar
    Join Date
    Apr 2004
    Posts
    10

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

    Many Thanks for your help!

    //Dagge

  5. #5
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,247

    Default Re: Formula for counting weeks /year

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

    http://www.xldennis.com/

    if not Ivan has,

    http://xcelfiles.homestead.com/Downloads_01.html

  6. #6
    MrExcel MVP erik.van.geit's Avatar
    Join Date
    Feb 2003
    Location
    Belgium 3272 Testelt
    Posts
    17,765

    Default 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
    I love Jesus

    email Erik

    founder of DRAFT

    my free Addins
    Table-It download & info
    Formula Translator 04

  7. #7
    New Member dagge's Avatar
    Join Date
    Apr 2004
    Posts
    10

    Default

    erik!
    Yes please, that would be great!

    Thanks in advance!

    //D

  8. #8
    MrExcel MVP erik.van.geit's Avatar
    Join Date
    Feb 2003
    Location
    Belgium 3272 Testelt
    Posts
    17,765

    Default Re: Formula for counting weeks /year

    your address is not visible
    so send me an email that I can reply
    (leaving now for some 5 hours)

    regards,
    Erik
    I love Jesus

    email Erik

    founder of DRAFT

    my free Addins
    Table-It download & info
    Formula Translator 04

  9. #9
    New Member dagge's Avatar
    Join Date
    Apr 2004
    Posts
    10

    Default 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. #10
    MrExcel MVP erik.van.geit's Avatar
    Join Date
    Feb 2003
    Location
    Belgium 3272 Testelt
    Posts
    17,765

    Default 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
    I love Jesus

    email Erik

    founder of DRAFT

    my free Addins
    Table-It download & info
    Formula Translator 04

Page 1 of 3 123 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com