Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Date

Resolved · High Priority · Version 2007

Reply Wed 19 Jan 2011, 12:57Delegate 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

For upcoming training course dates see: Pricing & availability

Reply Wed 19 Jan 2011, 14:51Trainer 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

Reply Wed 19 Jan 2011, 14:52Trainer 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.

Excel articles

· Importing Excel Data Into Access
· Microsoft Excel Training - Numerical excellence for all
· How To Ensure You Always Make A Complete Data Recovery
· The Pursuit of Excellence
· Automatically Insert The Time, Date Or Both In Excel

Please browse our web site to find out more about
excel classes and other Microsoft training courses.

Excel tip:

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help

3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)

View all Excel hints and tips