Can you clarify your question? What do you mean by "under the current
date"? Do you mean less than the current date and if so, by how much?

What is your goal? There may be an easier way.
"David" <dturner4_1999@yahoo.com> wrote in message
news:ua1NNV3uFHA.1256@TK2MSFTNGP09.phx.gbl...
> XL2K,
>
> Is there a formula I can copy down ColB on sheet2 that will result in the
> values in a column under the current date of sheet1?
>
> --
> David