0

I am currently working in a Power Automate Flow that needs a calculated column that acts as a counter towards an expiration date to be compared in an if statement to send alerts to multiple users letting them know "Hey your cert is expired, please re-take the cert again".

In order to do this I would like to have a calculated column that automatically counts days left towards the expiration date.

Improve this question

1 Answer 1

Reset to default
0

You could use the following calculated formula:

=DATEDIF(TODAY(),[expired date],"d")

As a result, it will get the left days:

enter image description here

If the answer is helpful, please click "√" on the left panel of the answer and kindly upvote it.

Improve this answer
1
  • Is this answer helpful for you? Please feel free to reply.
    – Yi Lu_MSFT
    Commented Jun 27, 2022 at 1:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.