Need help with Date/ and find most common denominator.

J

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top