Need help with Date/ and find most common denominator.
 

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.

Need help with Date/ and find most common denominator.
 

=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)


--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
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.

Need help with Date/ and find most common denominator.
 

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

"T. Valko" wrote:

=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)


--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
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.

Need help with Date/ and find most common denominator.
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
Great,, you have helped me before and as always you're spot on.
Thanks Much.

"T. Valko" wrote:

=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)


--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
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.