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
```