Announcements
I have file excel in shared point.
I want to count date in column Import Date to data today.
count = (date today - date in column Import Date)
Please guide me about it.
Hi @Anonymous
Please try using the Expression below to calculate the difference between the two dates.
div(sub(ticks('2021-08-20'),ticks('2021-12-01')),864000000000)
You can refer to screenshots as below:
Expression:
For more info you can refer to:
https://sympmarc.com/2021/02/22/calculate-the-difference-between-two-dates-in-power-automate/
https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/Flow-Calculate-Date-Diference/ba-p...
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-LilyW-msft How to replace 2021-12-01 follow data in excel?
Please see the formula in the details, the marked part is the date in excel
Best Regards.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 516
Valantis 477
Vish WR 470
