worksheet functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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
 
Back
Top