onCell return date about fast-formula-parser HOT 1 CLOSED

Fast-formula-parser adopts a similar convention to other spreadsheets and manages dates as numbers. If you want to specify as a string you can use DATEVALUE

  import DateFunctions from 'fast-formula-parser/formulas/functions/date';

  onCell: ({ sheet, row, col }) => {
      return DateFunctions.DATEVALUE('1999-9-9');
  }

This will return 36412 consistent with Google Sheets and Excel (if you apply number formatting you can see this.)

from fast-formula-parser.