help with formula
 

I am trying to place the following in cell:

From: today's date to 365 + todays date

can anyone supply the formula for this:
Thanks

help with formula
 

In Code:
Sub myDate()
Cells(1, 1) = Date + 365
End Sub

Placed in a Cell:
=TODAY() + 365

HTH--Lonnie M.

help with formula
 

One way:

="From: " & TEXT(TODAY(),"m/d/yyyy") & " to " &
TEXT(TODAY()+365,"m/d/yyyy")

or, using programming

Range("A1").Value = "From: " & Format(Date,"m/d/yyyy") & _
" to " & Format(Date + 365, "m/d/yyyy")

In article ,
"W. Dennis McClam" wrote:

I am trying to place the following in cell:

From: today's date to 365 + todays date

can anyone supply the formula for this:
Thanks