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?