how do i insert todays date in a spread sheet just prior to print

W

wayne h

wish to have excel automatically add date to same cell in spread sheet every
time it is opened.
 
M

Mike H

hi,

enter the formula

=today()

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
G

Gord Dibben

Your body description is at odds with your subject line.

Which is correct?

Before Printing or when workbook is opened?

You choose.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Sheets("Sheet1").Range("A1").Value = Format(Date, "mm-dd-yyyy")
End Sub

Private Sub Workbook_Open()
Sheets("Sheet1").Range("A1").Value = Format(Date, "mm-dd-yyyy")
End Sub


Gord Dibben MS Excel MVP

On Tue, 25 May 2010 10:39:01 -0700, wayne h <wayne
 

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

Excel Monthly Spread sheet. 12
Excel 2003 make 1 date cell automatically change another date cell 3
how can i "transfer data next row every day automatically" in XL 1
how do I achieve my xl spread sheet in Alphabetical order 1
Count of times a number is repeated by date? 2
Inserting rows in a protected sheet - Office 2003 2
adding/omitting/all the values prior to todays date 2
Create a document from a spread sheet using data from another spre 1

Top