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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

Formulas

ResolvedVersion 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:

Copying Values Without Formulas in Excel 2010

If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method:

Press Ctrl+C to copy the values in the cell. On the Home tab, click Paste and then click Paste Values.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Formulas

Formulas

RE: Formulas

Excel articles

Excel tip:

Copying Values Without Formulas in Excel 2010