If Statement for Date fields and blank cells

[Thomas Steve Hill]

I am trying to write an If Statement and need help please. If Cell A1 and Cell A2 are date fields and are Blank the formula needs to be in Cell A3 to show If a1 and or A2 is blank return "No Date Entered", now if A2 has a date... The area I cannot figure out is, If A2 has a date then the formula needs to say IF A2 is not blank then look at Todays()-7<= cell A2 then Cell A3 would show "Update". Thank you!!!

Cell A1</SPAN>		Cell B1</SPAN>		Formula in Cell C1</SPAN>
2/6/2013</SPAN>		3/24/2013</SPAN>		IF(ISBLANK(A1,"",B1,"","No Date", If(B1<=Todays()-7),"Update"</SPAN>

<TBODY>
</TBODY>

​

 

[Thomas Steve Hill]

I am using Excel 2003

 

[Thomas Steve Hill]

Would someone take a look and see if you can help me out, I am still trying to get it to work, if you need more information please let me know. Thanks much !!!