when conditions are met, enter today's date

[kmlynn1010]

Hello!!

So, I'm trying to say that when a1, b1, and c1 are all 0, enter today's date in d1. This is what I have so far:

=IF(AND(CJ6=0,CN6=0,CR6=0),"now"," ")

I've tried
=IF(AND(CJ6=0,CN6=0,CR6=0),=now," ")
=IF(AND(CJ6=0,CN6=0,CR6=0))=now," "
=IF(AND(CJ6=0,CN6=0,CR6=0),date," ")
=IF(AND(CJ6=0,CN6=0,CR6=0),=date," ")

I'm so clueless!

 

[Von Pookie]

Date will only return the current date in a macro. For formulas, use the TODAY worksheet function to return the current system date. Try:

=IF(AND(CJ6=0,CN6=0,CR6=0),TODAY(),"")