Help with iWork Numbers.

[emt1]

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.

 

[Spares]

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)

 

[emt1]

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

March 29, 2009 2:01:00 AM

 

[reclusivemonkey]

I don't want to make any additional columns.

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.