Output with excel formula (days elapsed)

[lvoh]

Hi,

I need to have the output (Excel spreadsheet) contain an Excel formula to calculate the days elapsed based on today's date. 

Column A: ID

Column B: Occurrence date

Column C: Days since occurrence date

In Excel I would put the following formula into C1 and apply to the remaining rows: =DAYS(TODAY(),B$1)

That way, each time the spreadsheet is opened, Column C reflects the number of days elapsed since the occurrence date. I know this calculation can be done in Alteryx but the result is static. 

How do I do this in Alteryx?

Thanks!

	A	B	C
1	123	20/09/21
2	124	18/09/21
3	125	15/09/21

[pdave87]

@cmcclellan I tested the above output in xlsx. Incase, excel generates extra character "@" in the output and errors out column C then follow below steps; 

1. Execute the Alteryx workflow

2. Open Excel file and perform - find & replace - @ with "" (empty space)

3. Excel provides the output in column C as expected.

Hope this helps.

My best,

Pratik

[ajankowski]

Is there a way to have the formula already executed when opening the Excel? 

I want the result of the formula to be shown in the cell, not the formula. But when I click into the cell I want to be able to see the formula. 

Right now, my formula is showing when I open the Excel output.