I'm working on a complaint log. I need to calculate both the days elapsed (Open date to current date) and days to close (open date to close date).
The cell data:
A2 = Date opened
AC2 = Date Closed
AD2 = Days open (calculated cell) - will display a) elapsed days until close date is entered in AC2, then b) it will change and display number of days the complaint was open.
I tried this but does not work. Issue seems to be the last IF Statement:
=IF(A2="","",IF(A2>DATE(2018,1,1),NETWORKDAYS(A2,TODAY()),IF(AC2>DATE(2018,1,1),NETWORKDAYS(A2,AC2()))))
Thank you in advance for your assistance.
Ken
Bookmarks