That's a reference to the first cell in the range. So if your range is B6:B36 then you'd use -ROW(B6). But, I think Zbor's formula will suit your needs better (it subtracts the first date from the last date thus giving a date difference in days, as opposed to counting the number of rows)?How about -Row(B1)?
Bookmarks