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

This free microsoft excel tips no 10 is telling to Include Print Date when You Print Report Automatically. Sometimes,it is important to put print date in your report to know when the report is printed. You can put 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 display the current date automatically.