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 » Dates

	98.1 % recommend us
	More live stats...

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

Training information:

Dates

Resolved · Medium Priority · Version 2007

Reply Tue 5 Aug 2008, 16:45Delegate Helen said...

Helen has attended:
Excel Intermediate course

Dates

How do you add to dates

For upcoming training course dates see: Pricing & availability

Reply Fri 15 Aug 2008, 13:02Trainer Amanda said...

RE: Dates

Hi Helen

Thank you for your question and welcome the forum.

You can use dates as part of formulas in Excel, as Excel stores a date as a number (or value).

For example if you have entered today's date into cell A1, you can create a formula reading =A1+30 which will add 30 days to the date in cell A1, and give you the date which is 30 days after this date.

Amanda

Excel articles

· A Beginners Guide To Formulas In Excel
· Fun Things I've Done With Excel
· Plug Into The Big Grid
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· An Introduction to Microsoft Excel: Top Features for the Excel Novice

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

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips