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" wrote in message
...
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