I have a sheet with a column containing the date format of "m/d/yy dddd". I want to be able to count the number of occurances of each day of the week.
I tried to format the next column as =text([cell], dddd). It works but the problem with this is that when it is copied into a row that does not currently have a corresponding date the entered the reference reads [saturday] and this will throw off my stats.
Any ideas???
I tried to format the next column as =text([cell], dddd). It works but the problem with this is that when it is copied into a row that does not currently have a corresponding date the entered the reference reads [saturday] and this will throw off my stats.
Any ideas???