The MONTH function takes just one argument, the date from which to extract the month. In the example shown, the formula is:
=MONTH(B4)
where B4 contains the date January 5, 2016. The MONTH function returns the number 1 representing the...Read more
The DAY function takes just one argument, the date from which you want to extract the day. In the example, the formula is:
=DAY(B5)
B5 contains a date value for January 5, 2016. The DAY function returns the number 5 representing the day...Read more
The NOW function takes no arguments; it is entered with empty parentheses. When you enter the NOW function in a cell, it will display the current date and time. Each time the worksheet is recalculated or opened, the date and time will be updated. To display only the time component, format the...Read more
The TODAY function takes no arguments; it is entered with empty parentheses. When you enter the TODAY function in a cell, it will display the current date. Each time the worksheet is recalculated or opened, the date will be updated. The TODAY function only inserts the date, time is not included...Read more
The goal is to count the number of cells in a given range, regardless of whether the cells are empty or not. Although Excel has several functions designed to count cells based on their contents, there is no built-in function for counting the total number of cells in a range. The classic...Read more
The COLUMNS function is fully automatic. When you provide a range to COLUMNS, it will return a count of all columns in the range. In the example, the formula in F6 returns 2, because there are 2 columns in the range B5:C10:
=COLUMNS(B5:C10) // count columns...Read moreThe ROWS function is fully automatic. When you provide a range to ROWS, it will return a count of all rows in the range. In the example, the formula in F5 returns 6, because there are 6 rows in the range B5:C10:
=ROWS(B5:C10) // count rows
...Read moreIn this example, the goal is to count the number of cells in B5:B15 that contain a given number of characters, where the number of characters n is provided as a variable in cell E4.
One way to solve this problem is to use the ...Read more
In this example, the goal is to count the number of cells in a range that do not contain errors. The best way to solve this problem is to use the SUMPRODUCT function together with the ISERROR function. You can also use the COUNTIF function or COUNTIFS function to exclude specific errors...Read more