Count number of Days

Christine419

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

AravindGP

Hi @Christine419

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

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.