How do I set up a calculation to exclude weekends?

Hello,
I am using Excel to schedule construction processes for homes. It is set up
by columns. Example "Column B..Row 2" gets the actual date typed in and I
set up calculations to add days to the schedule. For instance: Column B..Row
3 would be Row 2 +1. I want to have Saturday and Sunday automatically add
2 days to the calculation. I would need the new dates to carry forward. Is
this possible?

Look at the WORKDAY() function. HELP has the details; don't miss what it
says if you get a #NAME error

--
Kind regards,

Niek Otten

"Ken Proj mgr" <Ken Proj [email protected]> wrote in message
news:[email protected]...
> Hello,
> I am using Excel to schedule construction processes for homes. It is set
> up
> by columns. Example "Column B..Row 2" gets the actual date typed in and I
> set up calculations to add days to the schedule. For instance: Column
> B..Row
> 3 would be Row 2 +1. I want to have Saturday and Sunday automatically
> add
> 2 days to the calculation. I would need the new dates to carry forward.
> Is
> this possible?
>

Niek Otten,
Thanks for the direction. I will work on it and I will let you know how I
made out.

Thanks again.

Ken

"Niek Otten" wrote:

> Look at the WORKDAY() function. HELP has the details; don't miss what it
> says if you get a #NAME error
>
> --
> Kind regards,
>
> Niek Otten
>
> "Ken Proj mgr" <Ken Proj [email protected]> wrote in message
> news:[email protected]...
> > Hello,
> > I am using Excel to schedule construction processes for homes. It is set
> > up
> > by columns. Example "Column B..Row 2" gets the actual date typed in and I
> > set up calculations to add days to the schedule. For instance: Column
> > B..Row
> > 3 would be Row 2 +1. I want to have Saturday and Sunday automatically
> > add
> > 2 days to the calculation. I would need the new dates to carry forward.
> > Is
> > this possible?
> >
>
>
>

Niek Otten,
Ug! My spreadsheet is showing me the "#value" sign when I put in the
formula, "=workday(a10,a11). The formula work on another sheet that is
properly formatted, but not on the sheet I need it to owkr on. That too is
properly formatted. I made sure I am using a date and a figure to add. Any
ideas?


"Ken Proj mgr" wrote:

> Niek Otten,
> Thanks for the direction. I will work on it and I will let you know how I
> made out.
>
> Thanks again.
>
> Ken
>
> "Niek Otten" wrote:
>
> > Look at the WORKDAY() function. HELP has the details; don't miss what it
> > says if you get a #NAME error
> >
> > --
> > Kind regards,
> >
> > Niek Otten
> >
> > "Ken Proj mgr" <Ken Proj [email protected]> wrote in message
> > news:[email protected]...
> > > Hello,
> > > I am using Excel to schedule construction processes for homes. It is set
> > > up
> > > by columns. Example "Column B..Row 2" gets the actual date typed in and I
> > > set up calculations to add days to the schedule. For instance: Column
> > > B..Row
> > > 3 would be Row 2 +1. I want to have Saturday and Sunday automatically
> > > add
> > > 2 days to the calculation. I would need the new dates to carry forward.
> > > Is
> > > this possible?
> > >
> >
> >
> >

I'd guess that one of those cells isn't really what you expect.

if you put
=count(a10:a11)
in a separate cell
do you get 2?

Both of those cells should be numeric (a date is a number to excel).

If you don't, try reformatting each cell (as a date and general) and retype the
values in each cell.

Ken Proj mgr wrote:
>
> Niek Otten,
> Ug! My spreadsheet is showing me the "#value" sign when I put in the
> formula, "=workday(a10,a11). The formula work on another sheet that is
> properly formatted, but not on the sheet I need it to owkr on. That too is
> properly formatted. I made sure I am using a date and a figure to add. Any
> ideas?
>
> "Ken Proj mgr" wrote:
>
> > Niek Otten,
> > Thanks for the direction. I will work on it and I will let you know how I
> > made out.
> >
> > Thanks again.
> >
> > Ken
> >
> > "Niek Otten" wrote:
> >
> > > Look at the WORKDAY() function. HELP has the details; don't miss what it
> > > says if you get a #NAME error
> > >
> > > --
> > > Kind regards,
> > >
> > > Niek Otten
> > >
> > > "Ken Proj mgr" <Ken Proj [email protected]> wrote in message
> > > news:[email protected]...
> > > > Hello,
> > > > I am using Excel to schedule construction processes for homes. It is set
> > > > up
> > > > by columns. Example "Column B..Row 2" gets the actual date typed in and I
> > > > set up calculations to add days to the schedule. For instance: Column
> > > > B..Row
> > > > 3 would be Row 2 +1. I want to have Saturday and Sunday automatically
> > > > add
> > > > 2 days to the calculation. I would need the new dates to carry forward.
> > > > Is
> > > > this possible?
> > > >
> > >
> > >
> > >

--

Dave Peterson

Dave Peterson & Niek Otten,
I did it! I figured out what I was doing wrong. The Info on "Workday"
works fine. I had to add a number of lines to my sheet, but I was able to
schedule a house from start to finsish by entering a start date. I set up my
formula wrong.

Thank you both.

Ken

"Dave Peterson" wrote:

> I'd guess that one of those cells isn't really what you expect.
>
> if you put
> =count(a10:a11)
> in a separate cell
> do you get 2?
>
> Both of those cells should be numeric (a date is a number to excel).
>
> If you don't, try reformatting each cell (as a date and general) and retype the
> values in each cell.
>
> Ken Proj mgr wrote:
> >
> > Niek Otten,
> > Ug! My spreadsheet is showing me the "#value" sign when I put in the
> > formula, "=workday(a10,a11). The formula work on another sheet that is
> > properly formatted, but not on the sheet I need it to owkr on. That too is
> > properly formatted. I made sure I am using a date and a figure to add. Any
> > ideas?
> >
> > "Ken Proj mgr" wrote:
> >
> > > Niek Otten,
> > > Thanks for the direction. I will work on it and I will let you know how I
> > > made out.
> > >
> > > Thanks again.
> > >
> > > Ken
> > >
> > > "Niek Otten" wrote:
> > >
> > > > Look at the WORKDAY() function. HELP has the details; don't miss what it
> > > > says if you get a #NAME error
> > > >
> > > > --
> > > > Kind regards,
> > > >
> > > > Niek Otten
> > > >
> > > > "Ken Proj mgr" <Ken Proj [email protected]> wrote in message
> > > > news:[email protected]...
> > > > > Hello,
> > > > > I am using Excel to schedule construction processes for homes. It is set
> > > > > up
> > > > > by columns. Example "Column B..Row 2" gets the actual date typed in and I
> > > > > set up calculations to add days to the schedule. For instance: Column
> > > > > B..Row
> > > > > 3 would be Row 2 +1. I want to have Saturday and Sunday automatically
> > > > > add
> > > > > 2 days to the calculation. I would need the new dates to carry forward.
> > > > > Is
> > > > > this possible?
> > > > >
> > > >
> > > >
> > > >
>
> --
>
> Dave Peterson
>

Glad you fixed the problem.

Ken Proj mgr wrote:
>
> Dave Peterson & Niek Otten,
> I did it! I figured out what I was doing wrong. The Info on "Workday"
> works fine. I had to add a number of lines to my sheet, but I was able to
> schedule a house from start to finsish by entering a start date. I set up my
> formula wrong.
>
> Thank you both.
>
> Ken
>
> "Dave Peterson" wrote:
>
> > I'd guess that one of those cells isn't really what you expect.
> >
> > if you put
> > =count(a10:a11)
> > in a separate cell
> > do you get 2?
> >
> > Both of those cells should be numeric (a date is a number to excel).
> >
> > If you don't, try reformatting each cell (as a date and general) and retype the
> > values in each cell.
> >
> > Ken Proj mgr wrote:
> > >
> > > Niek Otten,
> > > Ug! My spreadsheet is showing me the "#value" sign when I put in the
> > > formula, "=workday(a10,a11). The formula work on another sheet that is
> > > properly formatted, but not on the sheet I need it to owkr on. That too is
> > > properly formatted. I made sure I am using a date and a figure to add. Any
> > > ideas?
> > >
> > > "Ken Proj mgr" wrote:
> > >
> > > > Niek Otten,
> > > > Thanks for the direction. I will work on it and I will let you know how I
> > > > made out.
> > > >
> > > > Thanks again.
> > > >
> > > > Ken
> > > >
> > > > "Niek Otten" wrote:
> > > >
> > > > > Look at the WORKDAY() function. HELP has the details; don't miss what it
> > > > > says if you get a #NAME error
> > > > >
> > > > > --
> > > > > Kind regards,
> > > > >
> > > > > Niek Otten
> > > > >
> > > > > "Ken Proj mgr" <Ken Proj [email protected]> wrote in message
> > > > > news:[email protected]...
> > > > > > Hello,
> > > > > > I am using Excel to schedule construction processes for homes. It is set
> > > > > > up
> > > > > > by columns. Example "Column B..Row 2" gets the actual date typed in and I
> > > > > > set up calculations to add days to the schedule. For instance: Column
> > > > > > B..Row
> > > > > > 3 would be Row 2 +1. I want to have Saturday and Sunday automatically
> > > > > > add
> > > > > > 2 days to the calculation. I would need the new dates to carry forward.
> > > > > > Is
> > > > > > this possible?
> > > > > >
> > > > >
> > > > >
> > > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson