Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 503 Super User 2025 Season 2
Tomac 321 Moderator
abm abm 237 Most Valuable Professional
