Workday Date Calculation
 

I am wanting to create a spreadsheet with multiple moving date targets. If I
enter a general date such as 01/03/07 with a timeframe of three business days
to complete the project, what formula do I use to generate the completion
date for me? Does anyone have any suggestions?

Workday Date Calculation
 

kdlilly, with your date in A1 put this in a cell and format as a date
=WORKDAY(A1,3)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kdlilly" wrote in message
...
I am wanting to create a spreadsheet with multiple moving date targets. If
I
enter a general date such as 01/03/07 with a timeframe of three business
days
to complete the project, what formula do I use to generate the completion
date for me? Does anyone have any suggestions?

Workday Date Calculation
 

To further add to Pauls suggestion. Start date in a1, timeframe in b1,
=workday(a1,b1) in c1 (or where ever). This will allow you to enter # days
without modifying the formula. i.e. (a1= 01/03/07, b1=5, results=1/10/07)

"Paul B" wrote in message
...
kdlilly, with your date in A1 put this in a cell and format as a date
=WORKDAY(A1,3)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kdlilly" wrote in message
...
I am wanting to create a spreadsheet with multiple moving date targets. If
I
enter a general date such as 01/03/07 with a timeframe of three business
days
to complete the project, what formula do I use to generate the completion
date for me? Does anyone have any suggestions?

Workday Date Calculation
 

When I enter the number value 3 in one cell and my date in another cell it
doesn't work for example. I entered the date 01/05/07 in one cell, and 3 in
another cell I typed =WEEKDAY(A3,B3) and it returns the value 01/04/1900.
Any suggestions?

"Mike G" wrote:

To further add to Pauls suggestion. Start date in a1, timeframe in b1,
=workday(a1,b1) in c1 (or where ever). This will allow you to enter # days
without modifying the formula. i.e. (a1= 01/03/07, b1=5, results=1/10/07)

"Paul B" wrote in message
...
kdlilly, with your date in A1 put this in a cell and format as a date
=WORKDAY(A1,3)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kdlilly" wrote in message
...
I am wanting to create a spreadsheet with multiple moving date targets. If
I
enter a general date such as 01/03/07 with a timeframe of three business
days
to complete the project, what formula do I use to generate the completion
date for me? Does anyone have any suggestions?

Workday Date Calculation
 

kdlilly, I think you want =WORKDAY(A3,B3) not WEEKDAY
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kdlilly" wrote in message
...
When I enter the number value 3 in one cell and my date in another cell it
doesn't work for example. I entered the date 01/05/07 in one cell, and 3
in
another cell I typed =WEEKDAY(A3,B3) and it returns the value 01/04/1900.
Any suggestions?

"Mike G" wrote:

To further add to Pauls suggestion. Start date in a1, timeframe in b1,
=workday(a1,b1) in c1 (or where ever). This will allow you to enter #
days
without modifying the formula. i.e. (a1= 01/03/07, b1=5,
results=1/10/07)

"Paul B" wrote in message
...
kdlilly, with your date in A1 put this in a cell and format as a date
=WORKDAY(A1,3)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from
it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kdlilly" wrote in message
...
I am wanting to create a spreadsheet with multiple moving date targets.
If
I
enter a general date such as 01/03/07 with a timeframe of three
business
days
to complete the project, what formula do I use to generate the
completion
date for me? Does anyone have any suggestions?

Workday Date Calculation
 

I receive the error "?NAME"

"Paul B" wrote:

kdlilly, I think you want =WORKDAY(A3,B3) not WEEKDAY
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kdlilly" wrote in message
...
When I enter the number value 3 in one cell and my date in another cell it
doesn't work for example. I entered the date 01/05/07 in one cell, and 3
in
another cell I typed =WEEKDAY(A3,B3) and it returns the value 01/04/1900.
Any suggestions?

"Mike G" wrote:

To further add to Pauls suggestion. Start date in a1, timeframe in b1,
=workday(a1,b1) in c1 (or where ever). This will allow you to enter #
days
without modifying the formula. i.e. (a1= 01/03/07, b1=5,
results=1/10/07)

"Paul B" wrote in message
...
kdlilly, with your date in A1 put this in a cell and format as a date
=WORKDAY(A1,3)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from
it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kdlilly" wrote in message
...
I am wanting to create a spreadsheet with multiple moving date targets.
If
I
enter a general date such as 01/03/07 with a timeframe of three
business
days
to complete the project, what formula do I use to generate the
completion
date for me? Does anyone have any suggestions?

Workday Date Calculation
 

Paul,
I have used another user's formula and it is doing exactly what I need it to
do except if the date falls on a Saturday or Sunday it defaults to the
previous Friday, I would like it to default to the following Monday. Can you
review the formula and advise on how to adjust. It would be greatly
aprpreciated. Thanks.
=IF(WEEKDAY(D18+E18,3)5,(D18+E18)-WEEKDAY((D18+E18)-5),D18+E18)

"Paul B" wrote:

kdlilly, I think you want =WORKDAY(A3,B3) not WEEKDAY
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kdlilly" wrote in message
...
When I enter the number value 3 in one cell and my date in another cell it
doesn't work for example. I entered the date 01/05/07 in one cell, and 3
in
another cell I typed =WEEKDAY(A3,B3) and it returns the value 01/04/1900.
Any suggestions?

"Mike G" wrote:

To further add to Pauls suggestion. Start date in a1, timeframe in b1,
=workday(a1,b1) in c1 (or where ever). This will allow you to enter #
days
without modifying the formula. i.e. (a1= 01/03/07, b1=5,
results=1/10/07)

"Paul B" wrote in message
...
kdlilly, with your date in A1 put this in a cell and format as a date
=WORKDAY(A1,3)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from
it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kdlilly" wrote in message
...
I am wanting to create a spreadsheet with multiple moving date targets.
If
I
enter a general date such as 01/03/07 with a timeframe of three
business
days
to complete the project, what formula do I use to generate the
completion
date for me? Does anyone have any suggestions?

Workday Date Calculation
 

kdlilly, see if the analysis toolpak add in is loaded, tools, addin, check
analysis toolpak, click in the cell with the formula and press F2 then enter
and see if it works
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


wrote in message news:771908FA-
...
I receive the error "?NAME"

"Paul B" wrote:

kdlilly, I think you want =WORKDAY(A3,B3) not WEEKDAY
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kdlilly" wrote in message
...
When I enter the number value 3 in one cell and my date in another cell
it
doesn't work for example. I entered the date 01/05/07 in one cell, and
3
in
another cell I typed =WEEKDAY(A3,B3) and it returns the value
01/04/1900.
Any suggestions?

"Mike G" wrote:

To further add to Pauls suggestion. Start date in a1, timeframe in
b1,
=workday(a1,b1) in c1 (or where ever). This will allow you to enter #
days
without modifying the formula. i.e. (a1= 01/03/07, b1=5,
results=1/10/07)

"Paul B" wrote in message
...
kdlilly, with your date in A1 put this in a cell and format as a
date
=WORKDAY(A1,3)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit
from
it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kdlilly" wrote in message
...
I am wanting to create a spreadsheet with multiple moving date
targets.
If
I
enter a general date such as 01/03/07 with a timeframe of three
business
days
to complete the project, what formula do I use to generate the
completion
date for me? Does anyone have any suggestions?