Using IF function to create a date

Closed
Beachball Posts 1 Registration date Monday September 10, 2012 Status Member Last seen September 10, 2012 - Sep 10, 2012 at 05:51 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 10, 2012 at 09:35 AM
Hello,
I am trying to create a cell that shows todays date if another cell has a particular value.

The formula I am currently using is:
IF(E9=L,TODAY) where L refers to whether a project is live or not. If the project is live, I want the cell to show todays date so I can then use DATEDIF in another cell to show the number of days the project has been live for.
I have tried various differnt versions and either I have too many or too few arguments. I just want it to remain blank if the argument is false.

Thanks




1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 10, 2012 at 09:35 AM
the format is
=IF(condition, true, false)
so
=IF(E9="L",TODAY, "")
0