Number of days between item created date and today's date or closed date

Copper Contributor

I have a SharePoint online list and I have added a calculated column called Days Request Open. I also have another column with the request status. In the days request open column, I want to displays the number of days between the date the list item was created and today. Or in the case where the item has been closed (request status would equal Request Complete or Cancelled), the number of days between the item created date and the date the item was changed to request complete or cancelled status. Is this possible just with a formula in the aforementioned calculated column or do I need some additional instruction set up using power apps for example?

0 Replies