View Single Post
  #1   Report Post  
carl
 
Posts: n/a
Default UUsing the NetworkDays Function with IF Statements

Hi. I am trying to use the Networkdays formula in ColF but need to have the
formula check the Billing Start, Billing End, FreeTrail Start, FreeTrail End
dates to determine the # of billing days. For example, for Product AN, since
the free trail starts after the billing start date and ends before the
billing end date the formula in ColF needs to count the business days between
12/1-12/6 (4) and 12/15-12/31 (13).

Thank you in advance.

B C D E F

Billing Start 1-Dec
Billing End 31-Dec
Customer Product Free Trail Start Free Trail End # Billing Days
ABC AN 6-Dec 15-Dec 17
ABC IACI 23
ABC LSI 6-Dec 15-Jan 4