Como restar fechas

[guriemar]

QUiero un flow que guarde en un excel segun una fecha y otro campo que me diga los dias transcurridos restando la fecha del dia de hoy menos la fecha que tengo

[v-yuazh-msft · Accepted solution]

Hi @guriemar,

Could you please share more details about your requirement in English?

Where are the excel saved in?

Will the date in excel table always in a same year?

I have made a test on my side and have created a excel table as below:

you could refer to screenshot below to crete the flow:

 

The expression in the Compose as below:

div(sub(ticks(utcNow()),ticks(items('Apply_to_each')?['Date'])),864000000000)

The flow would run successfully as below:

Best regards,

Alice

[guriemar]

Thanks for your support, just what I needed