How to use the function YEARFRAC on Alteryx

[salimaelalouaji]

Hello,

I'd like to know how to achieve the same functionality in Alteryx as I have in Excel. Could you please guide me on how to do this?

I want to calculate the residual life the same way i can on Excel.

Knowing that the cell C1 will always be the 31st December, 2022.

Thanks!

[cjaneczko · Accepted solution]

Try the following

[binuacs · Accepted solution]

@salimaelalouaji one way of doing this