3 day work week?

[blenderman]

I need to set up a formula to know when a specific product will run out. For instance, I have 100 lbs of rice, I cook 5lb of rice each day, but ONLY 3 days a week. I have used the workday function to figure when I use 5 lbs 5 days a week. I have tried NETWORKDAYS.INT, but can't seem to make that work. I am using Excel for MAC 2011. JUST FYI, this is how we will track the lbs of food and how many days is available in a feeding center for children in Honduras. Thanks in advance!


[TABLE="width: 291"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]DATE[/TD]
[TD]AMOUNT[/TD]
[TD]FOOD UNTIL[/TD]
[/TR]
[TR]
[TD]RICE[/TD]
[TD]1/7/16[/TD]
[TD]135[/TD]
[TD]02/23/16[/TD]
[/TR]
[TR]
[TD]LBS USED PER DAY[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]DAYS ON HAND[/TD]
[TD]33.75[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 208"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Jonmo1]

Networkdays.intl is the way to go.

The key is the string to determine weekdays/weekends
"0000011" <- that is Saturday and Sunday as weekends, Monday - Friday workdays.
It's 7 numbers representing the days of the week, beginning with Monday.
0 = Working Day
1 = Weekend Day

But it sounds like you actually want WORKDAY.INTL, not Networkdays..
But that string is the same for either function.

Can you post the WORKDAY function that you said works, but of coarse is a standard 5 day week

 

[cerfani]

what do you think... first I calculate Weeks on Hand by dividing the days by 3

then i take the weeks on hand and add the number of days to the initial date to calculate the Food Until Date...

 

[Jonmo1]

Pictures don't really help too much.

You said originally

I have used the workday function to figure when I use 5 lbs 5 days a week.

What is that formula you used that works based on a 5 day workweek?

And which days do you consider the workdays in a 3 day workweek?

 

[cerfani]

how do they not help? I explained each in detail and highlighted the cell so the formula is displayed, TS can see the columns and rows. How does that not help?

 

[Jonmo1]

how do they not help?

Sorry, I thought your post was from the OP.

 

[cerfani]

ah no problem