G
Guest
I am trying to build a spread sheet to help me check our billing software. I
would like to do this once a month, at the end of the month. I can input the
last day of the month in cell H2.
Is it possible to build a formula for Col G that can calculate the business
days as shown in this table ?
A B C D E F G
Service Business
Customer Start FreeStart FreeEnd ServiceStop Discontinued Days to
Bill
ABC 6/15/04 11/15/04 12/6/04 20
ABC 6/15/04 12/16/04 12
ABC 6/15/04 7/15/04 0
ABC 6/15/04 23
ABC 6/15/04 12/18/04 1/17/04 18
ABC 6/15/04 11/15/04 1/17/04 0
ABC TBD 0
ABC 6/15/04 9/15/04 0
ABC 6/15/04 9/15/04 0
Thank you in advance.
would like to do this once a month, at the end of the month. I can input the
last day of the month in cell H2.
Is it possible to build a formula for Col G that can calculate the business
days as shown in this table ?
A B C D E F G
Service Business
Customer Start FreeStart FreeEnd ServiceStop Discontinued Days to
Bill
ABC 6/15/04 11/15/04 12/6/04 20
ABC 6/15/04 12/16/04 12
ABC 6/15/04 7/15/04 0
ABC 6/15/04 23
ABC 6/15/04 12/18/04 1/17/04 18
ABC 6/15/04 11/15/04 1/17/04 0
ABC TBD 0
ABC 6/15/04 9/15/04 0
ABC 6/15/04 9/15/04 0
Thank you in advance.