Formulas

Resolved · Low Priority · Version 2007

Mon 10 Jan 2011, 16:10 Delegate Johanne said...

Johanne has attended:
Excel Introduction course
Excel Intermediate course

Formulas

Set a formula to show an action date in the future

Tue 11 Jan 2011, 18:52 Trainer Anthony said...

RE: Formulas

Hi Johanne, thanks for your query. Well the simplest way to show an action date in the future is simply to type it in, of course. However, to show a date that is always ten days from the current date you would use

=today()+10

Hope this helps,

Anthony

Tue 18 Jan 2011: Automatically marked as resolved.

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips

Formulas

Formulas

RE: Formulas

Excel articles

Excel tip:

Highlighting a data range