date function
=A1+B1 is a bit simpler, SUM seems unnecessary.
If you want to avoid weekends, use
=WORKDAY(A1,B1)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
not sure what you mean but
a1 b1 c1
10/1/2005 90 12/30/2005
c1 = sum(a1:b1)
--
Gary
"Bret" wrote in message
...
Need a formula to display the calculated date from the Start Date &
number
of
days.
ie: StartDate + Number of Days = Final Date.
Start Date:
2-1-05.
Number of Days
+ 90
= what date? Using the DATE function keeps failing.
thank you.
|