
Announcements
Hello,
My company is has a huge industry event coming up in January for which a large team is working together to get ready and has a team on Microsoft Teams to help coordinate for this event.
My team leader wants to send a daily reminder on the team to let everyone know how many days are left to the event so that everybody is aligned.
I tried to do the following, shown in this screenshot (https://i.imgur.com/SsVYwma.png) - I was trying to use an if statement that if the date is 18th January 2020, it should display zero else it should display 18th Jan minus DateNow. However, I quickly realised that I have no idea how to do this.
Any help would be great.
I would suggest you have a 3 variables for StartDate, EndDate, and CalculatedDate. Then, leverage the information provided in this post to calculate the number of days difference.
https://powerusers.microsoft.com/t5/General-Power-Automate/Subtract-dates/td-p/126119