I am calculating the cycle time for a process. For example: On my Weekends-Holiday column, #N/A means working days and Dayoff means weekends/holidays. My cycle time will need to exclude weekends and holidays. How can I setup a function to display #N/A = 1 (day) and Dayoff = 0 (day) at the Cycle Time column so I can sum up the days? Thanks you in advance for you help.
Date Weekends-holidays Cycle Time in days 12/18/09 #N/A 12/19/09 Dayoff 12/20/09 Dayoff 12/21/09 #N/A 12/22/09 #N/A 12/23/09 #N/A 12/24/09 #N/A 12/25/09 Dayoff 12/26/09 Dayoff 12/27/09 Dayoff 12/28/09 #N/A