Step 2: Convert Date Values to Numbers. To convert a date value to a number in Google Sheets, you can use the “DATEDIF” formula. This formula calculates the number of days between two dates, and you ...

Select the second item, Convert to Number, to instantly convert all selected values to real numbers, and in place, as shown in Figure C. Figure B. The SmartTag displays several possible problems.