Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Append check function with _Strict?

An answer in this question mentioned you can use ISDATE_STRICT in an array formula, and it worked.
I searched all over and could not find a reference to the use of _STRICT anywhere.

  1. Does this apply to all "IS" check functions?
  2. What exactly is it doing?
like image 765
Kris Avatar asked Jul 09 '26 21:07

Kris


1 Answers

Yes, unfortunately, I also don't see any articles/documentations about this one except this.

The link above is a list of sheets formulas, we can see _STRICT on 3 formulas.

ISDATE_STRICT, ISDATETIME_STRICT, ISTIME_STRICT

  1. The link above does answer your first question, it does not apply to all functions IS functions.
  2. Based on their behaviors, I guess that they strictly check if the value is treated and valid as date/time/datetime in sheets itself. Simply passing string as parameter will yield FALSE.

Testing:

output

Note:

  • I have a hunch why 25:02:00 for ISTIME_STRICT is still valid for time even though it goes past 24. Sheets automatically converted that value from the inputted value 25:02 thus suggests that what sheets treats as date/time/datetime, will always yield TRUE for those functions.
  • To test the hypothesis above, I inputted November 31, 2021 1:00 manually and it wasn't converted into 11/31/2021 01:00:00 automatically, it was still the same cell value because it wasn't treated as datetime variable by sheets, thus returning FALSE
like image 118
NightEye Avatar answered Jul 17 '26 09:07

NightEye



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!