Thanks Thanks:  0
Likes Likes:  0
Page 1 of 3 123 LastLast
Results 1 to 10 of 23

Thread: Formula for counting weeks /year

  1. #1
    New Member dagge's Avatar
    Join Date
    Apr 2004
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    14,149
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    14,149
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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,427
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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,829
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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,829
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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,829
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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

User Tag List

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
  •  
This website uses cookies
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.
     


DMCA.com