worksheet functions
 

How do I create a function that will add an amount according to the date? For
example if cell D3 is 6/10/05 then add 25(K4) if not then 0 in L4. I tried
IF(AVERAGE(D4),6/10/05,SUM(D3,J3),0 and it didn't work. Please help.

On Fri, 10 Jun 2005 08:47:31 -0700, "Nadji"
wrote:

How do I create a function that will add an amount according to the date? For
example if cell D3 is 6/10/05 then add 25(K4) if not then 0 in L4. I tried
IF(AVERAGE(D4),6/10/05,SUM(D3,J3),0 and it didn't work. Please help.

Your "date" may not be being interpreted correctly.

Suggestions:
1. Put the date in a cell and use a reference to that cell.
2. Use the totally unambiguous: DATE(2005,6,10)
3. You could try DATEVALUE("6/10/05") also.

My preference would be options 1 or 2.

--ron