dates & lists

[emmjaybee]

Is there any easy way of listing the dates between two
dates, for example. 24/07/04 - 19/07/04 = 5. But how
could I then show a list of the dates i.e.
Saturday 24 July 2004
Friday 23 July 2004
Thursday 22 July 2004
Wednesday 21 July 2004
Tuesday 20 July 2004
Monday 19 July 2004

Any help appreciated

 

[Bob Phillips]

In B1, enter 24/07/04
In C1, enter 19/07/04

In B2, enter

=IF(AND(B1+1>=B1,B1+1<=C1),B1+1,"")

and copy down as many rows as you think you will need.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Arvi Laanemets]

Hi

Enter the fist date (NB! Date, not datestring) into some cell, p.e. A1, and
dormat it as Custom "dddd dd mmmm yyyy"
Into cell below (A2) enter the formula
=A$1-ROW(A1)
Copy the formula down, until you have the end date listed too.

And the same in a somewhat improved version:
Into some cells, p.e. B1:B2, enter start and end dates
Into A1 entere the formula
=IF(B$1-ROW()+1<B$2,"",B$1-ROW()+1)
and format as Custom "dddd dd mmmm yyyy"
Copy the formula down for number of rows enough for your needs. You can
enter time intervals of various length, when you only have formulas ready.

 

[Domenic]

Hi,

Assuming:

A1 =7/24/2004
B1 =7/19/2004

=A1-B1

To automatically fill a list with dates:

A1 = 7/24/2004
A2 = 7/23/2004

Then, highlight both cells, A1 and A2, place your cursor over the bottom
right corner of A2 (cursor should turn into a cross), then click and
drag down.

Hope this helps!