Need help with Date/ and find most common denominator.

[Jman]

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.

 

[T. Valko]

=WEEKDAY(A1,2)

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

Maybe something like this:

=IF(A1="","error",WEEKDAY(A1,2))

How can i find the MOST common denominator between
a cell rangeA2: A2000.

Maybe this:

=MODE(A2:A2000)

 

[Jman]

Great,, you have helped me before and as always you're spot on.
Thanks Much.

 

[T. Valko]

You're welcome. Thanks for the feedback!