Help with if statement.

[GCC]

I work on project that needs a tracking at every stage. We have 3 stages (In-Progress, HOLD, COMPLETED). I have used "=IF(A3="In-Progress","In-Progress",IF(A3="HOLD","Query",TODAY()))" but when selected COMPLETED I am getting "43908" instead of current date. Can you help me correct this.
Also can you tell me how to add color coding to cell within the function. In-Progress should be in Yellow, HOLD in red, and COMPLETED in Green.

Appreciate your help.

 

[Michael M]

You need to reformat your cell as Date rather than text !!
Your second request needs to be addressed by using Conditional Formatting

 

[GCC]

You need to reformat your cell as Date rather than text !!
Your second request needs to be addressed by using Conditional Formatting

Thanks Michael. That helped.