98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Date
Date
Resolved · High Priority · Version 2007
Yolanda has attended:
Excel Intermediate course
Excel Advanced course
Date
I have a spreadsheet which I use every Monday morning and wish to have the date appear as 7 days later ie. have a spreadsheet as Mon 17th Jan 2011 and need to use it again on Mon 24th Jan 2011, is there any way the system can do this automatically or do I have to manually do it myself?
Thanks
RE: Date
Hi Yolanda
Thank you for your question.
To have your date automatically update itself on the day you open your Excel workbook (every Monday):
- Select the cell that you want the date to appear in
- Type: =today()
- After hitting Enter the date will appear and automatically update itself everytime the workbook opens.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post.
Regards,
Nafeesa
Microsoft Office Specialist Trainer
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Wed 26 Jan 2011: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Deleting cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + -. |