## [Solved] Day of the week calculations (Calc)

### [Solved] Day of the week calculations (Calc)

I have a spreadsheet containing a column of dates of the form mm/dd/yyyy. I would like to be able determine how many of these dates are "Mondays", "Tuesdays", "Wednesdays" etc. That is to say I would like to count how many of these dates fell on Monday, Tuesday etc.

SP

8/3/2010
Thank you all for your help. All of the solutions worked. Given the number of entries in the spreadsheet the solution that didn't require an extra column was the easiest to implement.

SP
Last edited by sid_patelson on Tue Aug 03, 2010 5:58 pm, edited 1 time in total.
OpenOffice Version 3.2.1
Operating Syatem Vista 64 bit
sid_patelson

Posts: 7
Joined: Fri Jul 23, 2010 7:31 pm

### Re: Day of the week calculations (Calc)

In my opinion, you need to use the "Weekday(Date;Type)" and "Countif(Range;Parameter)" functions.
(See them in OOo Help.)
WeekdayCount.ods
Tibor Kovacs, Hungary; AOO4.1.2; LO4.4.7 and Portable LO5.0.4 version on Win7x64Prof
Please, edit the topic's initial post, and add the word "[Solved]" at the beginning of the subject line - if your problem has been solved.

Zizi64
Volunteer

Posts: 3383
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

### Re: Day of the week calculations (Calc)

Or, once you have a column containing the Weekday(Date;Type) function, you can use Data Pilot to get a report of the frequencies.
Mr. Programmer
OpenOffice 3.2.0 Build 9483 on Mac OS X 10.9.5.   The locale for any menus or Calc formulas in my posts is English (USA).

MrProgrammer
Volunteer

Posts: 2393
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

### Re: Day of the week calculations (Calc)

With a matrix formula you can do it without an extra column, next the Zizi64 file with the formula added.
Attachments
WeekdayCount.ods