DATEVALUE Function: Difference between revisions
From Planfix
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
The DATEVALUE function converts a date stored as text into a number that corresponds to the date, for comparison or calculation purposes. | 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 | It is usually used in conjunction with the [[IF Function]] or subtraction. When subtracting, the result is the difference in minutes. | ||
Latest revision as of 23:23, 22 December 2019
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.