ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   print with displying date (https://www.excelbanter.com/excel-discussion-misc-queries/223576-print-displying-date.html)

ADIB

print with displying date
 
Hi, how can i take printout displying date on bottom without entering date
everyday in custom footer .is there any formula to update date daily for my
print page or any auto function in exel to shown current date on bottom when
i print . please suggest if anyone knows about it. Thanks

Gary''s Student

print with displying date
 
Pick a cell that will be printed and enter:
=TODAY()
--
Gary''s Student - gsnu200837


"ADIB" wrote:

Hi, how can i take printout displying date on bottom without entering date
everyday in custom footer .is there any formula to update date daily for my
print page or any auto function in exel to shown current date on bottom when
i print . please suggest if anyone knows about it. Thanks


ADIB

print with displying date
 
Thanks for your reply but i need this in print setup not in exel cell.please
give me any auto mathod entering date in print setup instead of entering date
everyday in custon footer. Thanks

"Gary''s Student" wrote:

Pick a cell that will be printed and enter:
=TODAY()
--
Gary''s Student - gsnu200837


"ADIB" wrote:

Hi, how can i take printout displying date on bottom without entering date
everyday in custom footer .is there any formula to update date daily for my
print page or any auto function in exel to shown current date on bottom when
i print . please suggest if anyone knows about it. Thanks


Dave Peterson

print with displying date
 
Check your other post.

ADIB wrote:

Hi, how can i take printout displying date on bottom without entering date
everyday in custom footer .is there any formula to update date daily for my
print page or any auto function in exel to shown current date on bottom when
i print . please suggest if anyone knows about it. Thanks


--

Dave Peterson

Gary''s Student

print with displying date
 
File PageSetup Header / Footer Custom Footer... Center Section
and touch the Calendar Button (fourth button)
--
Gary''s Student - gsnu200837


"ADIB" wrote:

Thanks for your reply but i need this in print setup not in exel cell.please
give me any auto mathod entering date in print setup instead of entering date
everyday in custon footer. Thanks

"Gary''s Student" wrote:

Pick a cell that will be printed and enter:
=TODAY()
--
Gary''s Student - gsnu200837


"ADIB" wrote:

Hi, how can i take printout displying date on bottom without entering date
everyday in custom footer .is there any formula to update date daily for my
print page or any auto function in exel to shown current date on bottom when
i print . please suggest if anyone knows about it. Thanks


ADIB

print with displying date
 
Thanks Dave

"Dave Peterson" wrote:

Check your other post.

ADIB wrote:

Hi, how can i take printout displying date on bottom without entering date
everyday in custom footer .is there any formula to update date daily for my
print page or any auto function in exel to shown current date on bottom when
i print . please suggest if anyone knows about it. Thanks


--

Dave Peterson



All times are GMT +1. The time now is 09:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com