If formula is not showing the result of the DATE

Good Afternoon Excel Team,

For a reason the formula is not working anymore, is not showing the result of the enter Date once the Fields contains information.

This is the formula Im using:

=IF(D177<>"",IF(F177<>"",F177,NOW()),"")

Can you help me solve please.

Thank in advance as always

Jesus Huerta

Presumably you mean the formula in Database!F4. All cells are in the Database worksheet. D177 is blank, so D177<>"" is FALSE, so your formula is correctly returning the 3rd argument of the 1st IF call. I'm outlining the correct evaluation in red text below.

Formula:

Please Login or Register  to view this content.

If you were expecting the result of NOW(), you'd need to change D177<>"" or eliminate the entire outer IF call.

Sorry.. None of both answers work.

This is the logic behind this.. If we capture or enter DATA into Field D4. I want F4 to show the Date & time that this Entry was enter?

Hope this helps to fix my formula.

Thanks

Sorry, You are correct looking at the wrong field. Was D4. Not D177. Remove the first If. Now it works.

Thank you.