Hello, I need some help please! I am trying to create a formula in Excel 2013 that basically states, if in G2 is the text "Completed" then insert today's date in H2 This is what i have so far but it's not working! =IF("Completed"=(J17)=TRUE,"=Today()"=(K17)) I would really appreciate the help!
This question generated 14 answers. To proceed to the answers, click here.
This thread is current as of August 15, 2014.