Date format in Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In the header there is an icon that will automatically insert the current
date on the header. Is there a way to put the previous day as the date in
the header? I've tried different formulas but they don't work.
 
Hi

An easy way is a small macro in the ThisWorkbook module:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader = Format(Date - 1, "dddd mmm dd yyyy")
End Sub

HTH. best wishes Harald
 
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

Date command in Excel headers 10
Dates-Automatically entered in cells 7
Format of Header Date 2
Header in row to column 1
Macro for Dates 5
Change Header on Multiple Sheets without Changing Other Formatting 1
Date: Week in header 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top