Help with iWork Numbers.

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

  1. emt1 macrumors 65816

    Joined:
    Jan 30, 2008
    Location:
    Wisconsin
    #1
    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

    Joined:
    Feb 16, 2009
    #2
    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
    =COUNTIF(A1:A15,"Monday")

    or in general terms

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

    Joined:
    Jan 30, 2008
    Location:
    Wisconsin
    #3
    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

    reclusivemonkey

    Joined:
    Jun 2, 2008
    Location:
    Sowerby Bridge, West Yorkshire, UK
    #4
    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