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.
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.
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