Formulating Date in Excel 2013

Question

I am using MS Office Excel 2013 in English, I have the following question.

I used this formula "=IF(OR(ISNUMBER(D5),ISTEXT(D5)),TODAY(),"not posted")" to place todays date in C5, when I enter text or a number in D5, but I get a number in the returned value, instead of the actual date.

What is incorrect in the formula? explicitly: I enter "yes" in D5 I get "42621" in C5 instead of the current date.

Answer 1

Take the cursor to the intended cell and press ALT + H + N + Short Date. This should do the trick!