search

LesterLyu / fast-formula-parser

Parse and evaluate MS Excel formula in javascript.
https://www.npmjs.com/package/fast-formula-parser
MIT License
454 stars 63 forks source link

Adding numbers to dates #25

Closed rmdort closed 3 years ago

rmdort commented 3 years ago

Any idea how i can do this

=TODAY() + 1 => should return tomorrow

Right now, it converts date to serial number and adds 1

LesterLyu commented 3 years ago

You will need to convert the serial number to date by using SSF.

rmdort commented 3 years ago

Got it thanks