Sheet() and Sheets()

Getting total number of sheets (Sheets), or ID of this sheet (Sheet). The two new formulas Sheet() and Sheets() can do well, yes not perfect, we still need to have …

Highlight dates dynamically

Conditional formatting is another powerful feature in Excel, especially when you combine it with functions A simple function as in below if you set it up inside Conditional formatting, can …

Limited Ceiling

The function CEILING (CEILING.Math as of Excel 2016) is a very good powerful function. It allows you to round  number to any value up Unlike ROUND, ROUNDUP and ROUNDDOWN, that …