# Count number of Days

Options

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

• ✭✭✭✭✭
Options

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

Thanks,

Aravind

Reach out for any help on licenses, configuration, or training

• Options

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

• Options

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

• ✭✭✭✭✭
Options

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

Thanks,

Aravind

Reach out for any help on licenses, configuration, or training

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!