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

	98.1 % recommend us
	More live stats...

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

Training information:

Excel

Resolved · Low Priority · Version 2003

Reply Tue 7 Oct 2008, 17:13Delegate Matthew said...

Matthew has attended:
Excel Intermediate course

Excel

How do you post a formula using the today function to work out how many days would be left on a contract?

For upcoming training course dates see: Pricing & availability

Reply Fri 10 Oct 2008, 16:47Trainer Andrew said...

RE: Excel

Hi Matthew

Thanks for your question. You could use a formula as follows:

=A1-today()

Where A1 contains the expiry date of the contract. You may need to format the result as a general number.

I hope this helps - let us know if you need any further information.

Kind regards,

Andrew

Excel articles

· Make A Custom Sort List In Excel
· What Do The Formula Error Messages Mean In Excel?
· Want To Get To Grips With The Different SUM Functions In Excel?
· How To Embed Fonts In Excel
· Interesting Things About Charts In Excel 2003

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

Excel tip:

Use RANDBETWEEN to generate random numbers

There may be occassions where you need to generate random numbers in your spreadsheet. Use the RANDBETWEEN function to generate random numbers between two values that you specify.

The function looks like this:

=randbetween(LOW,HIGH)

where LOW is the lowest number you want generated; and HIGH is the highest number you want generated.

This formula will work with both positive and negative LOWs and HIGHs. Also it will only generate integer numbers unless forced to do otherwise by the following:

=randbetween(LOW*10^PRECISION,
HIGH*10^PRECISION)/(10^PRECISION).

where PRECISION represents the levels of decimal precision needed (i.e. if you need numbers with one decimal place, PRECISION would be 1; 2 for two decimal places and so on).

One final note, if the RANDBETWEEN formula does not work in your spreadsheet or returns a "#NAME" error, you need to install the Analysis Toolpak Add-In. You will need to press F2 then Enter following the installation.

View all Excel hints and tips