Previous Topic Next Topic

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




Related:

1 response

Answer 1 / 1
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

Similar discussions

Why can't I bridge connect?
ryno -
Qiqi -

15 responses
Hi Guys how to create an account for facebook with my company em
Ramu -
Ahmadzai -

2 responses
If FB account is disabled, can I create a new one?
tuckerdognc -
hamsheena -

7 responses
How to bridge connections from laptop to pc
TEchNoob -
Nilesh Katekar -

13 responses
cannot get my home pc to bridge connections
darrenrst -
corona_king -

3 responses