SHEETS
Information

Returns the number of sheets in a reference

Syntax:

=SHEETS([reference])

Example:

=SHEETS()