DAYS360 Formula
I'm trying to move various spreadsheets from Excel to Smartsheet but I keep needing the DAYS360 formula. It is very common to calculate loans based on 360 day years so monthly figures remain constant (at 30 days/mo). I was very surprised to see that this formula is not supported by Smartsheet. Is there a way to mimic it? Any idea if/when Smartsheet will support this formula?
Comments
-
Hi Jeff,
As you have found, Smartsheet currently doesn't have a function similar to DAYS360. When you have a moment, submit a Product Enhancement Request to let our Product team know that you'd like to have this function in Smartsheet.
For a list of all the date functions available, please see: https://help.smartsheet.com/functions
Help Article Resources
Categories
Check out the Formula Handbook template!