help with formula

  • Thread starter Thread starter W. Dennis McClam
  • Start date Start date
W

W. Dennis McClam

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
 
In Code:
Sub myDate()
Cells(1, 1) = Date + 365
End Sub

Placed in a Cell:
=TODAY() + 365

HTH--Lonnie M.
 
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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Migrate IMAP Email to Office 365 Easily 1
Need help exporting an Office 365 mailbox to PST 2
Migrating from Amazon WorkMail to Microsoft 365 2
How to migrate Gmail to Office 365? 2
Conditional formatting of dates 2
Count Dates & Return as % 2
Excel Formula - Count Dates from another Sheet 8
today's date static 1

Back
Top