Date Formulas Closed

Question

I am wanting to know how to make a copy of the same spreadsheet many times and when I do I want the date on the spreadsheet to change automatically each time a copy is made.  For Example: if my spreadsheet says February 24, 2015 on the first copy I want the second copy that comes out to say February 25, 2015 without me having to print the first date and then change the date myself and then make a copy of it and then change the date again and make a copy because that would take way to long to do if I am wanting to do everyday until December 31, 2016.  Please Help me I need to figure this out very soon because it is for school.  Thanks in Advance

cmarzahn · Answer

Not sure if this is what you need.  Have you considered using a footer to date the sheet when printing?  It's found under Page Setup then Custom Footer.  Then use the Icons for Date and/or time to insert the line at the bottom of a page.

I often use it for items that change, such as rosters, so I can track which is the most recent version.  

So it might look something like this:
Printed on &[Date] at &[Time]

Or if you need the date in a formula you can use the Now() function.  Using "=Now()" and then formatting it might help.  That function can be formatted to show date, time, etc.

Hope that helps.  If not, send a msg and I'll try to help further.

Date Formulas

1 response

Similar discussions

Subscribe To Our Newsletter!