TODAY() function is not working

[subhajitnag28]

TODAY() function is not working, it is giving NaN.

[sanchit3008]

I see that the TODAY() function from formulajs returns a date object, but the sheet can support only string and number. Would setting the cell value as string like Sat Jun 01 2024 00:00:00 GMT+0530 (India Standard Time) work for you?

[sanchit3008]

Following functions have the same issue -

• WORKDAY
• DATE
• DATEVALUE
• TODAY
• EDATE
• EOMONTH
• NOW
• WORKDAYINTL

[sanchit3008]

@zyc9012 what are your thoughts on this? I was thinking to have a check in execfunction in formula.ts to see if the result of the formula parser is a date, and to return result.toString() if it is a date.

[subhajitnag28]

Hi @sanchit3008 I think it should work. Can you please help to make the change?

[sanchit3008]

I have the changes ready, will wait for @zyc9012's inputs for a couple of days

[subhajitnag28]

Thanks @sanchit3008

[sanchit3008]

553