I have a question.

When i enter this formula it gives me the type of day in a number form ex 1
equals monday, 2 equals tuesday and so on.

=WEEKDAY(A1,2)

In column A 1 down i have dates, some cells down are also blank.
when there is no date it shows number 6 egualing saturday.

How can i get this formula to show me error instead of 6 when there is no
date in column A.


Also i have a second question.
How can i find the MOST common denominator between a cell range
A2: A2000. these cells only conatin containing numbers 1 thru 6.