how do you calc a 6 day work week

More clarification required, do you want to calculate working days between
two dates based on a 6 day work week, or project a future date based on
number of working days added, or something else? Do you want to take holidays
into account?

"tkirchoff10" wrote:

how do you calc a 6 day work week

Thanks ..Both
1.calculate working days between
two dates based on a 6 day work week,

2. project a future date based on
a 6 working daysfor your help.

Thanks for your help
"daddylonglegs" wrote:

More clarification required, do you want to calculate working days between
two dates based on a 6 day work week, or project a future date based on
number of working days added, or something else? Do you want to take holidays
into account?

"tkirchoff10" wrote:

how do you calc a 6 day work week

Thanks
I need both
1. calculate working days between two dates based on a 6 day work week
2. project a future date based on 6 working days..no Holidays

Thanks for your help

"daddylonglegs" wrote:

More clarification required, do you want to calculate working days between
two dates based on a 6 day work week, or project a future date based on
number of working days added, or something else? Do you want to take holidays
into account?

"tkirchoff10" wrote:

how do you calc a 6 day work week

Let's say 6 day work week (Mon-Sat)
Assuming A1 is your start date
A2 is your end date

A3 =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))={2,3,4,5,6,7}))


"tkirchoff10" wrote:

how do you calc a 6 day work week

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))={2,3,4,5,6,7}))

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))1))

=SUM(INT((WEEKDAY(A1-{1,2,3,4,5,6},2)+A2-A1)/7))

Biff

"Teethless mama" wrote in message
...
Let's say 6 day work week (Mon-Sat)
Assuming A1 is your start date
A2 is your end date

A3 =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))={2,3,4,5,6,7}))


"tkirchoff10" wrote:

how do you calc a 6 day work week

To project a future date based on start date in A1 and number of days to add
in B1 and assuming a 6 day week (Monday to Saturday)

=A1-WEEKDAY(A1,3)+INT(7/6*(B1+MIN(5,WEEKDAY(A1,3))))

"T. Valko" wrote:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))={2,3,4,5,6,7}))

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))1))

=SUM(INT((WEEKDAY(A1-{1,2,3,4,5,6},2)+A2-A1)/7))

Biff

"Teethless mama" wrote in message
...
Let's say 6 day work week (Mon-Sat)
Assuming A1 is your start date
A2 is your end date

A3 =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))={2,3,4,5,6,7}))


"tkirchoff10" wrote:

how do you calc a 6 day work week

Thank u sir,

the foll formula gives good results,
=A1-WEEKDAY(A1,3)+INT(7/6*(B1+MIN(5,WEEKDAY(A1,3))))

can u tell me were can i fit holidays or list of holidays in above formula to exclude holidays from the calculation.

thanks,



EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

I created this with a 5 work week and a 6 work week table.

To include the holidays, just simply populate it with the dates (as formatted in the example) in the Holidays Tab (formula is until Row 20).