Simple sell date - buy date formula

Hey all. Trying to do a column equation that shows how long an item has been sitting on a shelf.

Lets call the two columns Sell Date and Buy Date. I'd like to see the amount of days between Sell Date and Buy Date. If I bought inventory on 1/1 and sold it on 1/10, I'd like it to read "9' for "Days on Shelf" column.

What's the best way to do this?

Find more posts tagged with

Formulas

Accepted answers

All comments

Dale Murphy

@Mycelus You could use SmartSheet native functionality and use the column called Duration. You could even show the length of "Days on Shelf" on a Gantt chart.

Otherwise, I use a formula along the lines of ([Sell Date] - [Buy Date]) regularly. The function NETDAYS is a bit more sophisticated.

(I recommend activating a Gantt chart and let the SmartSheet functionality manage it. Just beware of vacation and weekend days.) =days

Cheers,

Mycelus

I was able to do =([Sold Date]@row - [Bought Date]@row) and that did the trick, thank you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.