Page 1 of 1

[Solved] Day of the week calculations (Calc)

Posted: Tue Jul 27, 2010 7:05 am
by sid_patelson
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

Re: Day of the week calculations (Calc)

Posted: Tue Jul 27, 2010 8:36 am
by Zizi64
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 242 times

Re: Day of the week calculations (Calc)

Posted: Tue Jul 27, 2010 5:03 pm
by MrProgrammer
Or, once you have a column containing the Weekday(Date;Type) function, you can use Data Pilot to get a report of the frequencies.

Re: Day of the week calculations (Calc)

Posted: Fri Jul 30, 2010 11:02 pm
by mriosv
With a matrix formula you can do it without an extra column, next the Zizi64 file with the formula added.