Thread: date function
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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.