D
dannyboy213
****_*NETWORDAYS__AND_CALENDARS*_
I desperately need help in creating a formula to calculate free days at
the terminal. I have two different dates. First date is the day that the
container became available. Second date is the day the container
returned.
1.If the container became available during business day, for instance
4/10/06 (Monday), I have a total of 5 business days to return the
container, this is including the day it became available. Which means
the last free day is 4/14/06 (Friday). So another example is if the
container became available on 4/11/06 (Tuesday), the last free day is
4/17/06 (Monday).
However, if the container became available on a weekend like 4/9/06
(Sunday), then the free days is only 4 business days. Which means that
the last free day is 4/13/06 (Thursday).
So last part of the formula is that *_IF__*I went over the free days
(detention days), I want the formula to count how many
*_CALENDAR_DAYS_* it went over, IF I did not go over the free days then
leave it *_blank_*. Here is an example:
Available Date: 4/8/06 (Saturday)
Returned Date: 4/15/06 (Saturday)
Last Free Day: 4/13/06 (Thursday)
*Detentions Days: 2 Days*
I desperately need help in creating a formula to calculate free days at
the terminal. I have two different dates. First date is the day that the
container became available. Second date is the day the container
returned.
1.If the container became available during business day, for instance
4/10/06 (Monday), I have a total of 5 business days to return the
container, this is including the day it became available. Which means
the last free day is 4/14/06 (Friday). So another example is if the
container became available on 4/11/06 (Tuesday), the last free day is
4/17/06 (Monday).
However, if the container became available on a weekend like 4/9/06
(Sunday), then the free days is only 4 business days. Which means that
the last free day is 4/13/06 (Thursday).
So last part of the formula is that *_IF__*I went over the free days
(detention days), I want the formula to count how many
*_CALENDAR_DAYS_* it went over, IF I did not go over the free days then
leave it *_blank_*. Here is an example:
Available Date: 4/8/06 (Saturday)
Returned Date: 4/15/06 (Saturday)
Last Free Day: 4/13/06 (Thursday)
*Detentions Days: 2 Days*