Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with formula
In Code:
Sub myDate() Cells(1, 1) = Date + 365 End Sub Placed in a Cell: =TODAY() + 365 HTH--Lonnie M. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |