Related:
- Date Formulas
- Little alchemy formulas - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Excel spreadsheet formulas - Guide
- Ms excel marksheet formulas pdf - Guide
- Excel formulas in french - Guide
1 response
cmarzahn
Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
Feb 24, 2015 at 05:29 PM
Feb 24, 2015 at 05:29 PM
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.
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.
Feb 24, 2015 at 07:35 PM
Feb 25, 2015 at 06:43 PM
Mar 21, 2015 at 01:06 AM