Problem with DAYS360

[Lee_Yeong]

Good evening everyone. I would like to use DAYS360 in spreadsheet formula to calculate some recurrent interest, but somehow the formula changes to DAYS374 instead in google spreadsheet.

Any solution?

[Zhifeng_Lin]

Hi,
I don’t think Google Sheets has a function called DAYS374?
It does have the DAYS360 function though – https://support.google.com/docs/answer/3093042?hl=en&ref_topic=3105385

Also check out this article about spreadsheet formulas (vs App Formulas) – https://help.appsheet.com/en/articles/961393-spreadsheet-formulas

Thanks

[Lee_Yeong]

Yesterday, the function seems to be deranged.
AutoCompute became Days374 everytime an entry is made in the apps.

Today, everything works as usual.

Anyway thanks.