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

New Contributor

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 Replies
best response confirmed by EliasGuzman (New Contributor)


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

In another cell, enter the formula




Format the cell with this formula as a date.