Count number of Days

I have tried looking here for answers but not able to find the formula that will work. I have a Install Date and Install End Date. These fields are date fields. The Days field I want the formula to appear is a text field.

I need to calculate the number of days.

4/09/2024-04/-9/2024 would be 1 day

4/10/24 - 4/12/25 would be 3 days

Find more posts tagged with

Accepted answers

AravindGP

Hi @Christine419

You can multiple the duration column to the amount in a separate text/number column. =[Duration]@row * [Amount column]@row

All comments

RicardoHiSa

You need only rest the days. For example i use this formula to have the number of days between this two dates.

=TODAY() - Date@row

Christine419

I can use duration but I need to multiply the number of days in duration to a $ amount

AravindGP

Hi @Christine419

You can multiple the duration column to the amount in a separate text/number column. =[Duration]@row * [Amount column]@row

marqpoma

Hi! I'm trying to calculate the number of days aging, I used the =TODAY() but I'm getting "invalid operation" when using the formula.

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.