Hello Everyone,
I have two columns, OpenDate and CloseDate. They are formatted as type DATE.
I need to know the number of days between the date an issue was opened and when it was closed. If CloseDate is blank, then the issue is still open, so the calculation should use today's date to do the calculation.
Here's what I was initially thinking: C2 is a field in the CloseDate Column, and B2 is a field in OpenDate
=IF(ISBLANK(C2),DATEVALUE(TODAY())-DATEVALUE(B2), DATEVALUE(C2)-DATEVALUE(B2))
This of course just returns #VALUE!
I think it's because the DATEVALUE function needs a string to operate on, and isn't looking in the cell?
Any suggestions?
Thanks in advance for your help!
Bill
Bookmarks