How to get how many weeks left in month in Numbers?

Discussion in 'Mac Apps and Mac App Store' started by nelly22, Aug 15, 2016.

  1. nelly22 macrumors 6502

    Joined:
    Sep 29, 2009
    #1
    How i can get in Numbers how many weeks there is still in this month?

    For example if now is 20th day of the month then there is about 10 days left which is about 1.5 weeks so it should return number 1.5.

    And another formula which does same but rounds down this number to 1.
     
  2. Moakesy macrumors regular

    Moakesy

    Joined:
    Mar 1, 2013
    Location:
    UK
    #2
    I can do the first bit.....

    Assuming your date (the 20th) is in cell B3, then place this in the cell you need

    =(EOMONTH(B3,0)-B3)

    That will give you 11d for August (so 20th August to 31st August is 11 days).

    The easy bit, dividing 11 by 7 (to turn that into weeks), and then using the ROUNDDOWN function to make 1.57 weeks show as 1 week is proving more difficult, as Numbers does not want to let me handles these values as simple numbers, rather than days.

    To be honest, I'm far more knowledgable of Excel....Numbers is still new to me.

    Hope it helps
     
  3. nelly22 thread starter macrumors 6502

    Joined:
    Sep 29, 2009
    #3
    Thanks. I can't figure out how to get it work.
     
  4. jjhoekstra macrumors regular

    Joined:
    Apr 23, 2009
    #4
    I always use YEARFRAC(). It needs a start date (fi TODAY()) an enddate ( fi EOMONTH()) and you have to decide how many days in the year, normally 365.

    Multiply the number you get with 365 and you have the number of days. Divide that by 7 and you have the number of weeks. Etc, etc.
     
  5. nelly22 thread starter macrumors 6502

    Joined:
    Sep 29, 2009
    #5
    Thanks this works! Is it possible to have variation of this which tells how many thursdays are still left in month?
     

Share This Page