[Solved] Day of the week calculations (Calc)

Discuss the spreadsheet application

[Solved] Day of the week calculations (Calc)

Postby sid_patelson » Tue Jul 27, 2010 7:05 am

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.

Thank you for your help.

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)

Postby Zizi64 » Tue Jul 27, 2010 8:36 am

In my opinion, you need to use the "Weekday(Date;Type)" and "Countif(Range;Parameter)" functions.
(See them in OOo Help.)
WeekdayCount.ods
(10.16 KiB) Downloaded 129 times
Tibor Kovacs, Hungary; AOO4.0.1, LO3.6.4, LO4.2.2 on WinXPprof.SP3
Zizi64
Volunteer
 
Posts: 1784
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Day of the week calculations (Calc)

Postby MrProgrammer » Tue Jul 27, 2010 5:03 pm

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.6.8.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 1747
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Day of the week calculations (Calc)

Postby mriosv » Fri Jul 30, 2010 11:02 pm

With a matrix formula you can do it without an extra column, next the Zizi64 file with the formula added.
Attachments
WeekdayCount.ods
(10.8 KiB) Downloaded 87 times
LibreOffice 3.5.4 AOo-3.4 on Win 7 Ultimate
mriosv
 
Posts: 650
Joined: Mon Mar 09, 2009 1:12 am
Location: Galiza (España)


Return to Calc

Who is online

Users browsing this forum: Richarda44, RusselB and 29 guests