Calculate years doing business


#1

Hello,

I’m trying to create a formula where the value is today’s date minus date of the first invoice:

Today’s date - Date of first invoice = Years doing business

I would need to enter the “Date of the first invoice”. Not sure if I need 2 columns or just 1.

I know I could have a formula in a 3rd column of {column 1}-{column 2} but I would like to have something closer, such as 3.78 years instead of 3.

Thanks for the help.


#2

How I got to work:

DATETIME_DIFF({Today’s date}, {Date of the first invoice}, ‘days’)/365

I tried the following, hoping to get decimal, such as 4.5 but result was just 4 or 4.0 or 4.00 (depending on Formatting.):

DATETIME_DIFF({Today’s date}, {Date of the first invoice}, ‘years’)

So, I had to use days and then divide by 365 to get 4.5, etc.