I'm working on a list in SharePoin 2010.
I need to know how long a job has been open before it glot closed. I also need it to count how many days it has been open if it hasn't been closed yet. This formula counts how many days it has been since it opened:
=DATEDIF([Date Raised],[Todays Date],"d")
and this is what I had in mind to stop the count when it got closed
=DATEDIF(([Status]="Open")[Date Raised],[Todays Date],"d")
The idea being that if the status = open, then count the days. This is obviously incorrect as I get an error message informing me so.
How do I get it to work?