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.
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.