Trying to print today's date when another cell has a certain condition

[EliasGuzman]

Hey all. 

I think I have a pretty easy question, just can't figure it out. I'm trying to write a function in Excel that will print today's date when a cell parallel to it has "Completed" selected from the drop-down. Not even sure where to start as I'm completely new to Excel. I have the IF and TODAY() functions, just not sure how to get them to work together.

[#2 · Accepted solution]

@EliasGuzman 

Let's say the cell with the dropdown is B2.

In another cell, enter the formula

=IF(B2="Completed",TODAY(),"")

Format the cell with this formula as a date.

[#3]

That did it, thank you!