I am using the
NETWORKDAYS formula to count days between 2 days for a series of different transaction dates. I want the count to exclude weekends and holidays on each transaction date. However, the result doesn't come out as I expected.
For example, the transaction between 1/26 and 1/27 should have been 1 day, but it is counted as 2 days. Is there any easy way to count the days? I have tried to use a simple formula such as
=C9-C8, which would give me 1 day. Because I have a large amount of data to work with, it would be very difficult use that approach and excluding weekends and holidays.
Date on Column C Result on Column F Row 7: 1/20/10 12:00 AM Row 8: 1/26/10 12:00 AM 5 Row 9: 1/27/10 12:00 AM 2 Row10: 1/28/10 12:00 AM 2