must be easy, trick

[rplim2016]

Hello Guys,



=IF(AND(CELL("format",A2)="D4",
CELL("format",B2)="D4",
CELL("format",C2)="D4",
CELL("format",D2)="D4"),
"is in DATE Format",)

above formula is to check if all values in A2 to D4 are in date.
my boss challenged me to simplify above formula.

please help me.

 

[rplim2016]

is it possible to array the formula guys?

 

[James006]

Just tested again the Array Formula for you ...

https://www.mrexcel.com/forum/excel...ets-simple-count-post5247706.html#post5247706

And it does work ...

As an alternative ... a simple UDF can also perforrn the task ...

Function CountDates(rng As Range) As Long
Dim c As Range
Dim x As Long
  For Each c In rng
    If IsDate(c.Value) = True Then x = x + 1
  Next c
CountDates = x
End Function

P.S. For your info the Cell function does not accept an Array ...

 

[rplim2016]

Just tested again the Array Formula for you ...

https://www.mrexcel.com/forum/excel...ets-simple-count-post5247706.html#post5247706

And it does work ...

As an alternative ... a simple UDF can also perforrn the task ...

Function CountDates(rng As Range) As Long
Dim c As Range
Dim x As Long
  For Each c In rng
    If IsDate(c.Value) = True Then x = x + 1
  Next c
CountDates = x
End Function

P.S. For your info the Cell function does not accept an Array ...

Thanks a lot james!

 

[James006]

You are welcome ...