Numbers - Column Fill

Discussion in 'Mac Apps and Mac App Store' started by JWmacuser, Mar 28, 2011.

  1. JWmacuser macrumors newbie

    Joined:
    Aug 6, 2010
    #1
    In Excel, you can fill a column with ONLY weekday dates using edit/fill/column, date, weekdays. Is there any such quick way to do ONLY weekdays in Numbers?
     
  2. VisionTeacher macrumors newbie

    Joined:
    Jun 11, 2011
    #2
    Fill weekdays in numbers

    It took a little working through, and maybe there is a button I dont know about but...

    1) type in start date
    2) directly under that cell, insert the following function - assuming that A2 is your cell in step 1

    =IF(WEEKDAY(A2,Sunday is 1)=7,(A2)+2, IF(WEEKDAY(A2,Sunday is 1)=6,(A2)+3,(A2)+1))

    It looks complicated but it's really just an IF statement with another IF statement embedded in the first if-false.

    It drove me crazy trying to find this out so if if still looking for this answer, I'd be happy to explain the steps further.

    As much as I love Apple products I think this is one instance where Excel is just plain better than Numbers as far as a spreadsheet goes. And I am not a mathematician by any means.
     
  3. john1620b macrumors member

    Joined:
    Apr 29, 2009
    #3
    It's not quite as easy, but you can do:

    1. Insert > Date & Time
    2. Insert > Fill > Fill Down
    3. Format > Create Custom Cell Format...
    4. Set the "Type" to "Date & Time"
    5. Change the elements so it only shows the day of the week

    Once you have the custom format set up, you should be able to re-use it quickly. Good luck

    Edit: Nevermind, that doesn't actually answer your question. It looks like VisionTeacher's solution is the best one.
     

Share This Page