How to overlay date functions

Resolved · Low Priority · Version 2003

John has attended:
Excel Intermediate course
Project Intermediate course

by - delegate John [2 posts] (2008 May 30 Fri, 15:45) Reply

BETWEEN TWO DOCUMETS

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: How to overlay date functions

by - trainer Amanda diamond contributer [1208 posts] (2008 Jun 11 Wed, 14:26) Reply

Hi John

Thank you for your question.

Can you please explain a bit more about what you would like to achieve and we'll see if we can offer some suggestions.

Thank you
Amanda

· Prepare for your MOS Certification with MS Excel Courses
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· What's Better Than the Help Function in Excel? Microsoft Training
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks

Please browse our web site to find out more about
excel course 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.