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/202404/9/2024 would be 1 day
4/10/24  4/12/25 would be 3 days
Best Answer

You can multiple the duration column to the amount in a separate text/number column. =[Duration]@row * [Amount column]@row
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Answers

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

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

You can multiple the duration column to the amount in a separate text/number column. =[Duration]@row * [Amount column]@row
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!