Formula for number of days item is open

I am trying to set up a column that will calculate how many days an item is active. I have a column called “RPIW Date” that I will use as the start date. Then I have a “Closed Date” column that an automation fills in when the status is changed to Done. So I want it to calculate number of days from RPIW Date to Closed Date is there is a date in the Closed Date Column otherwise I want it to calculate number of days from RPIW Date to Today. I can’t get the formula to work.

Here is the formula I am trying:

IF ({Closed Date} = "",ROUND(DAYS(TODAY(),{RPIW Date}), ROUND(DAYS ({Closed Date},{RPIW Date})))

Any help would be appreciated.

@tcarnley

Try this:

IF({Close Date} = "", ROUND(DAYS(TODAY(), {RPIW Date}),0), ROUND(DAYS({Close Date}, {RPIW Date}),0))

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: The ITEM ID column - What most people don’t know.
Contact me directly here: Contact – The Monday Man

1 Like

Thank you Jim. That worked! I had watched some of your videos before posting this. They were helpful also.

@tcarnley

I’m glad that you are finding the videos helpful!!


Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: A Status Column Tip - When is “Done” really DONE?
Contact me directly here: Contact – The Monday Man