Excel Tips No 10 : Include Print Date when You Print Report Automatically

by admin on June 25, 2011

  • Sharebar

This free microsoft excel tips no 10 is telling to Include Print Date when You Print Report Automatically. Sometimes,it is vital to place print date in your report to know when the report is printed. You can place it on report header or footer. This tips tell ho to write print date automatically.

Its simple, just type the formula below in your report :
="Report printed on "& TEXT(NOW(),"mmmm d,yyyy at h:mm AM/PM")
or
="Report printed on "& TEXT(NOW()," dd mmmm yyyy at h:mm AM/PM")

Here is the result :

You can modify the date format.
Just copy the formula to all your report and it will show the current date automatically.

Incoming search terms:

Tagged as: Automatically, Current Date, Date, excel, Excel Tips, Footer, Free Excel, Free Microsoft Excel, Include, Microsoft, print, report, Report Header, tips, Yyyy

Leave a Comment

Previous post:

Next post: