Hi,
I'm looking for a formula that will allow me to figure
the difference between the stock purchase dates I have
entered in a weekly numbered work sheet. If the entered
dates are within the weekly dates which are entered
across row 1 (D1 through J1) I need to perform the
calculation. If the dates are outside of the weekly
dates I need to enter zero in a cell thereby not
performing the calculation.
I am presently doing this manually and am having trouble
finding sample source code. If you have a such a web
site please inform me.
I wish to thank you in advance for any help.

I have each cell formated as a date and have entered
Sundays date in D1, Monday date in E1, Etc. Format as
01/05/03.
-----Original Message-----
How do you have them listed across D1 through J1?


On Sat, 9 Aug 2003 13:49:04 -0700, "Bob Podmore"

wrote:

Hi,
I'm looking for a formula that will allow me to figure
the difference between the stock purchase dates I have
entered in a weekly numbered work sheet. If the
entered
dates are within the weekly dates which are entered
across row 1 (D1 through J1) I need to perform the
calculation. If the dates are outside of the weekly
dates I need to enter zero in a cell thereby not
performing the calculation.
I am presently doing this manually and am having
trouble
finding sample source code. If you have a such a web
site please inform me.
I wish to thank you in advance for any help.

.