Cacher is the code snippet organizer for pro developers

Count NON empty cells in range:

=COUNTIF(range,"<>"&"")

(  =COUNTIF(B:B,"<>"&"")-1  )



Count EMPTY cells in range:

=COUNTIF(range,"")




Cell Formatting:

Datum:
------------------------
German (DE)  - NNN TT.MM


Datum homepage:
------------------------
English (UK) - DD.MM.YY;@