Learning Computer Skill Blog

                                DATE & TIME  FUNCTION   1. TODAY ( ) :- Summary  The Excel TODAY function returns the current date, updated continuously when a worksheet is changed or opened. The TODAY function takes no arguments. You can format the value returned by TODAY using any standard date format. If you need current date and time, use the  NOW function . Purpose  Get the current date Return value  Valid Excel date Syntax  =TODAY () Arguments  Usage notes  The TODAY function takes no arguments, and returns the current date, updated whenever a worksheet is changed or opened. You can also use F9 to force the worksheet to recalculate and update the value. If you need a static date that won't change, you can  enter the current date using the keyboard shortcut  Ctrl + Shift + ; If you need current date and time, use the  NOW function . Examples = TODAY () // current date = TODAY () - 7 // on

STATISTICAL FUNCTION   1. MAX FUNCTION () Summary  The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values TRUE and FALSE, and text values. Purpose  Get the largest value Return value  The largest value in the array. Syntax  =MAX (number1, [number2], ...) Arguments  number1  - Number, reference to numeric value, or range that contains numeric values. number2  - [optional] Number, reference to numeric value, or range that contains numeric values. Usage notes  The MAX function can be used to return the largest value from a set of data. For example, the slowest time in a race, the hightest temperature, or the top sales number. Arguments can be provided as constants, or as cell references or ranges, for example: = MAX ( 5 , 10 ) = MAX ( A1 , A2 , A3 ) - MAX ( A1:A10 ) 2. MIN FUNCTION () Summary  The Ex