Thread: date function
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
PaulD PaulD is offline
external usenet poster
 
Posts: 92
Default date function

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