Mac Forum / Applications / Excel / September 2007

I have researched to determine a formula that would produce a date
based on an existing date and then adding a numeric value.

Basically, if the project starts today (8/31/2007), 3 BUSINESS days it
should be completed.

So here is the formula that I am using:
=DATE(YEAR(DATEVALUE(A1))+0,MONTH(DATEVALUE(A1))+0,DAY(DATEVALUE(A1))
+3)

This formula gives me an error. If I use actual dates in the A1
reference in quotations, I get August 3, 2007 as the answer...doesn't
make sense.

The information that I got from the Microsoft site was the following:
How to Increase Dates Incrementally
To increase a date by a number of years, months, or days, use the
formula
=DATE(YEAR(reference)+value1,MONTH(reference)+value2,DAY(reference)
+value3)
where reference is either the date value or cell reference that
contains the date, and value1, value2, and value3 are the increments
by which you want to increase the year, month, and day, respectively.

For example, to increase a date by one month, the formula is:
=DATE(YEAR(DATEVALUE("6/20/96")),MONTH(DATEVALUE("6/20/96"))+1,
DAY(DATEVALUE("6/20/96")))

My problem is that I don't want the date to be static or constant, I
want to reference the date in a cell (which it says you can do). The
other issue is that the VALUE 1,2,3 I also want to reference it in a
cell.

HELP!!!