DAYS360 Formula

jeffdimock

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?

Alejandra

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