Date

Resolved · High Priority · Version 2007

Wed 19 Jan 2011, 12:57 Delegate Yolanda said...

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

Wed 19 Jan 2011, 14:51 Trainer Nafeesa said...

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

Wed 19 Jan 2011, 14:52 Trainer Nafeesa said...

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 courses