On Sun, 29 Nov 2009 16:27:01 -0800, Victoria
wrote:

hello gurus

Imagine two columns (part of a larger table) , the first with dates, and the
second showing the difference (in days) between a date and the one above it.
My problem is that there are varying numbers blank rows between the dates.
I'd like it to look like this...

COLUMN A COLUMN B
Aug 27, 08 0

Dec 01, 08 96
Jan 21, 09 51



Jan 22, 09 1
Mar 08, 09 55

What formula could I use in the cells of Column B?

Much thanks
Victoria

A1: Aug 27, 08
B1: 0
B2: =IF(A2="","",A2-MAX($A$1:A1))
and fill B2 down as far as needed.

Assumes dates in A are in ascending order.
--ron