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?

Find more posts tagged with

Finance

Formulas

Real Estate

Enhancement Request

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
Join distinct collect with contains
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)