Show column how many days since effective date

[inglexjc]

Trying to create a column that shows how many days since something was effective.  I have a data tabe that gives me 

Agency Name	Client Name	Effecitve Date
Test	Jane Doe	12/23/2024

I created a Date Table.  But can't seem to get the formula to work to show how many days since the Effecitve Date.

[Fowmy · Accepted solution]

@inglexjc 

Add this as a Calculated Column to the above table:

Days Since Effective Date =
INT ( TODAY () - [Effecitve Date] + 1 )