Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

JWmacuser

macrumors newbie
Original poster
Aug 6, 2010
4
0
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?
 
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.
 
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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.