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.
