Unable to support for date formulas

ltfschoen

If I add a the date to two cells F9 (28/05/2024) and E9 (30/05/2024) and format them as date format, and then in another cell G9 I write the formula =DAYS(F9,E9), it just outputs #VALUE! instead of outputting how many days between those dates.

If I enter a formula =F9+7 in cell H9 to populate that cell with the date a week after the date entered in F9, it also outputs #VALUE! in cell H9.

Mathilde

Hello,

As we are integrating OnlyOffice to power our Spreadsheet application, can you check if it works on their official demo instance?

Please report back your findings and don't hesitate to add screenshots if necessary. This way we'll be able to understand where the issue might come from.

Thanks in advance.