DATEVALUE Function

From PlanFix
Jump to: navigation, search

The DATEVALUE function converts a date stored as text into a number that corresponds to the date, for comparison or calculation purposes.

It is usually used in conjunction with the IF Function or subtraction. When subtracting, the result is the difference in minutes.


Format:

*DATEVALUE(String)


where:

The string corresponds to one of the following formats:

  • DD-MM-YYYY
  • DD-MM-YYYY HH:MM
  • DD.MM.YYYY
  • DD.MM.YYYY HH:MM
  • YYYY-MM-DD
  • YYYY-MM--DD HH:MM


Example:

IF(D>DATEVALUE("01-08-2015");B*2;B)


In this example, for each report row in the column that contains the specified formula, the formula checks to see if the date in this row of column D is larger than August 1, 2015. If it is, it returns the value from this row of column B multiplied by 2. Otherwise, it returns just the value from column B.


Go To