Excel Formula

[yimveasna]

Hello Sir,
Can you let me know the formula in Excel:
I have a table as below:



This table, At the column "A,Status" when i Put the word" Completed", it's will automatic put current Date to Column "B, Row 2".
But i don't know after that when tomorrow arrived,at the column "B,Row 2", change date too.

 

[archer]

Hi,

Use this one, in the next line
3.
"=IF(A:A="Complete",B2+1)"

With this one, when you enter "Complete" in A3, it will automatically put the date in B3.

 

[yimveasna]

Dear archer,
I follow your way and I got the result "FALSE" when i put "Completed"
Thanks

 

[TanyaC]

Dear archer,
I follow your way and I got the result "FALSE" when i put "Completed"
Thanks

That's because you have not provided a value for the false outcome

IF(condition, true, false).

So..

=IF(A:A="Complete",B2+1,"")

Will will give you a null instead of the FALSE.

Tanya