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.![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
=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.
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)