Forum Discussion
Solved
Trying to print today's date when another cell has a certain condition
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.
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.
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.
- That did it, thank you!
