How to use ISBLANK function in MS EXCEL?

ISBLANK

What Does It Do?

This function will determine if there is an entry in a particular cell.

It can be used when a  spreadsheet has blank cells which may cause errors, but which will be filled later as the data is received by the user. Usually the function is used in conjunction with the =IF() function which can test the result of the = ISBLANK() Syntax              =ISBLANK(CellToTest) Formatting Used by itself the result will be shown as TRUE or FALSE. Example The following example shows a list of cheques received by a company. When the cheque is cleared the date is entered. Until the Cleared date is entered the Cleared column is blank. While the Cleared column is blank the cheque will still be Outstanding. When the Cleared date is entered the cheque will be shown as Banked. The =ISBLANK() function is used to determine whether the Cleared column is empty or not.

How to use date formula in Excel?

DATE

What Does It Do?

This function creates a real date by using three normal numbers typed into separate cells.

Syntax

=DATE(year,month,day)

Formatting

The result will normally be displayed in the dd/mm/yy format. By using the Format,Cells,Number,Date command the format can be changed.