LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nested IF Function, Date Comparing, and NetworkDays Function carl Excel Worksheet Functions 2 December 29th 04 09:57 PM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 01:00 AM
MS Excel Function - Networkdays Nilesh Inamdar Excel Worksheet Functions 3 November 26th 04 07:10 PM
Re-assigning weekend days in "Networkdays" Function sts75 Excel Discussion (Misc queries) 0 November 26th 04 10:45 AM


All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"