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.

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.

just in case you wanted that in code

Sub AddDate()
Dim StartDate As Date
Dim NumDays As Integer
Dim FinalDate As Date

StartDate = #10/1/2005#
NumDays = 90
FinalDate = StartDate + NumDays
MsgBox FinalDate
End Sub

This will show a messagebox with the date 12/30/2005
Paul D

"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.
:
:

=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.