date

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Date

Date

resolvedResolved · 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.


 

Excel tip:

Deleting cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + -.

View all Excel hints and tips


Server loaded in 0.08 secs.