# 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

2 Likes

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

1 Like

@tcarnley

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

Hey,
Do you have any suggestion how can format the number of days to months, weeks and days?
Means “40” will be:
1 month, 1 week, 3 days.

Thank you

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.