#EXCEL FUNCTIONS SERIAL NUMBER#

Let us say you have a date in cell A2 and you want cell B2 to display the value вЂњ doneвЂќ if the date comes before or on the same date as вЂњ вЂќ and display вЂњ not doneвЂќ otherwise. When you pass this as a parameter to the DATEVALUE function, it takes a look at the text inside the double quotes, identifies it as a date and then converts it to an actual Excel date value. If you put a date within quotes, it is essentially a text or string value.

#EXCEL FUNCTIONS SERIAL NUMBER#

This function converts a date in text format to a serial number that Excel can recognize as a date. If you want to use a date in your IF functionвЂ™s logical test, you can wrap the date in the DATEVALUE function. Using the IF Function with DATEVALUE Function Here are a few ways in which you can incorporate date values into your IF functionвЂ™s logical_test parameter. So you cannot use a logical test as вЂњ>вЂќ in your IF function, as it will simply see the value вЂњ вЂќ as text. It interprets them as regular text values. Unfortunately, unlike other Excel functions, the IF function cannot recognize dates. It may look like IF formulas for dates are the same as IF functions for numeric or text values, since they use the same comparison operators. Here are some of the comparison operators that you can use when comparing dates, along with what they mean: Symbol Unlike numbers and strings, comparison operators when used with dates, have a slightly different meaning. You can then use the IF function as follows: =IF(A2=10,'yes','no')

value_if_false is the value that you want the IF function to return if the logical_test evaluates to FALSEДЇor example, say you want to write a statement that will return the value вЂњ yesвЂќ if the value in cell reference A2 is equal to the 10, and вЂњ noвЂќ otherwise.

value_if_true is the value that you want the IF function to return if the logical_test evaluates to TRUE.

The result of this parameter is either TRUE or FALSE

logical_test is the condition or criteria that you want the IF function to test.

The syntax for the IF function is as follows: IF( logical_test,, )

Using the IF Function with Future or Past Dates.

Using the IF Function with the TODAY Function.

Using the IF Function with DATEVALUE Function.