DAYS360 Formula

jeffdimock
edited 12/09/19 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!