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 ...
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!