Adding Day to find a next weekday

No, I don't. I was thinking this formula would be used to identify the next
workday after a weekend. For example, if something was received 07/30/08,
and is due 10 days from that date, it would be due 08/09/08. However, since
that date falls on a weekend, I'd want the due date in the spreadsheet to
show up as 08/11/08, the first available work day. I guess I'm using the
wrong formula, or maybe I'm doing something else wrong.

Thanks for your help.

GAF

"Peo Sjoblom" wrote:

Do you have a range named holidays where you put public holidays?


--


Regards,


Peo Sjoblom

"gafern" wrote in message
...
Ron:

Thank you for sharing your knowledge.

I'm running Excel 2003 on Windows XP. I've followed the steps you
described
in this earlier thread, using the =WORKDAY formula. Cell A4 contains my
original date and has a date format. Cell B3 has the number 10 (for the
number of workdays) and is general format (I've also tried number format).
The formula of =WORKDAY(A4+B3-1,1,holidays) is in cell B4 and that had a
date
format as well. I am getting the #NAME? error. I have the Analysis
ToolPak
add-in showing in Tools.

Can you think of something I may be doing wrong?

Thanks, in advance, for your consideration.

GAF

"Ron Rosenfeld" wrote:

On Thu, 8 Feb 2007 13:44:00 -0800, Dolt
wrote:

I don't know understand why it works but it does
Thanks


You're welcome.

How it works:

1. Take original date
2. Add one less than the required number of days
3. Then add one Workday.

If adding one workday results in a weekend day or holiday, the Workday
function
will skip over that.


--ron

Well you can't use a name like holidays if you don't have defined as a name.
If you don't want any public holidays in your calculations just leave that
part out

=WORKDAY(A4+B3-1,1)


if you want to exclude holidays put the public holidays for 2008 in a range
like H1:H10,
select H1:H10 and in the name box above the header of column A type Holidays
and press enter
Now your first formula should work. Of course you can leave the range empty
and add the dates later
but once you have named the range you shouldn't get a name error anymore as
long as ATP is
installed

--


Regards,


Peo Sjoblom

"gafern" wrote in message
...
No, I don't. I was thinking this formula would be used to identify the
next
workday after a weekend. For example, if something was received 07/30/08,
and is due 10 days from that date, it would be due 08/09/08. However,
since
that date falls on a weekend, I'd want the due date in the spreadsheet to
show up as 08/11/08, the first available work day. I guess I'm using the
wrong formula, or maybe I'm doing something else wrong.

Thanks for your help.

GAF

"Peo Sjoblom" wrote:

Do you have a range named holidays where you put public holidays?


--


Regards,


Peo Sjoblom

"gafern" wrote in message
...
Ron:

Thank you for sharing your knowledge.

I'm running Excel 2003 on Windows XP. I've followed the steps you
described
in this earlier thread, using the =WORKDAY formula. Cell A4 contains
my
original date and has a date format. Cell B3 has the number 10 (for the
number of workdays) and is general format (I've also tried number
format).
The formula of =WORKDAY(A4+B3-1,1,holidays) is in cell B4 and that had
a
date
format as well. I am getting the #NAME? error. I have the Analysis
ToolPak
add-in showing in Tools.

Can you think of something I may be doing wrong?

Thanks, in advance, for your consideration.

GAF

"Ron Rosenfeld" wrote:

On Thu, 8 Feb 2007 13:44:00 -0800, Dolt

wrote:

I don't know understand why it works but it does
Thanks


You're welcome.

How it works:

1. Take original date
2. Add one less than the required number of days
3. Then add one Workday.

If adding one workday results in a weekend day or holiday, the Workday
function
will skip over that.


--ron

Thank you. I'd obviously overlooked defining a name for public holidays.
I'll give this try.

Thanks, again!

GAF

"Peo Sjoblom" wrote:

Well you can't use a name like holidays if you don't have defined as a name.
If you don't want any public holidays in your calculations just leave that
part out

=WORKDAY(A4+B3-1,1)


if you want to exclude holidays put the public holidays for 2008 in a range
like H1:H10,
select H1:H10 and in the name box above the header of column A type Holidays
and press enter
Now your first formula should work. Of course you can leave the range empty
and add the dates later
but once you have named the range you shouldn't get a name error anymore as
long as ATP is
installed

--


Regards,


Peo Sjoblom

"gafern" wrote in message
...
No, I don't. I was thinking this formula would be used to identify the
next
workday after a weekend. For example, if something was received 07/30/08,
and is due 10 days from that date, it would be due 08/09/08. However,
since
that date falls on a weekend, I'd want the due date in the spreadsheet to
show up as 08/11/08, the first available work day. I guess I'm using the
wrong formula, or maybe I'm doing something else wrong.

Thanks for your help.

GAF

"Peo Sjoblom" wrote:

Do you have a range named holidays where you put public holidays?


--


Regards,


Peo Sjoblom

"gafern" wrote in message
...
Ron:

Thank you for sharing your knowledge.

I'm running Excel 2003 on Windows XP. I've followed the steps you
described
in this earlier thread, using the =WORKDAY formula. Cell A4 contains
my
original date and has a date format. Cell B3 has the number 10 (for the
number of workdays) and is general format (I've also tried number
format).
The formula of =WORKDAY(A4+B3-1,1,holidays) is in cell B4 and that had
a
date
format as well. I am getting the #NAME? error. I have the Analysis
ToolPak
add-in showing in Tools.

Can you think of something I may be doing wrong?

Thanks, in advance, for your consideration.

GAF

"Ron Rosenfeld" wrote:

On Thu, 8 Feb 2007 13:44:00 -0800, Dolt

wrote:

I don't know understand why it works but it does
Thanks


You're welcome.

How it works:

1. Take original date
2. Add one less than the required number of days
3. Then add one Workday.

If adding one workday results in a weekend day or holiday, the Workday
function
will skip over that.


--ron