Help with iWork Numbers.

Discussion in 'Mac Apps and Mac App Store' started by emt1, May 5, 2009.

  1. emt1 macrumors 65816

    Jan 30, 2008
    I have a column that is a list of dates (in date & time format)

    How can I make a formula to count the number of Mondays (or any weekday) in that main list?

    I don't want to make any additional columns.
  2. Spares macrumors member

    Feb 16, 2009
    I'll take a stab at this... im assuming the days are written (ie. Monday, Tuesday, etc etc)
    If your column goes A1:A15 then it would be as follows

    or in general terms

    =COUNTIF(range, criteria)
  3. emt1 thread starter macrumors 65816

    Jan 30, 2008
    The list is a list of dates, in date/time format. For example, one cell contains

    March 29, 2009 2:01:00 AM
  4. reclusivemonkey macrumors 6502


    Jun 2, 2008
    Sowerby Bridge, West Yorkshire, UK
    I can't think of a way you can do with *without* adding additional columns.

    I can only tell you how I would do it in Excel, but that should work for numbers.

    The WEEKDAY formula will tell you which dates are a Monday. You can then simply use COUNTIF to count the number of Mondays. You can obviously do this for any weekday, or add them all together to get a total number of weekdays.

Share This Page