Logic test - can i add date for a true result?

[melmason]

Working on a table where i have a cell that eventually will have "yes" entered in it. once Yes has been entered a date is then entered. Can i use a logic test where when "yes" is true it inserts the date?

this is what i have now ...

=IF(V17="yes","d/mm/yyyy","")


but d/mm/yyyy is what comes out not the actual date?
Can this be done or am i dreaming?

 

[Rick Rothstein]

Working on a table where i have a cell that eventually will have "yes" entered in it. once Yes has been entered a date is then entered. Can i use a logic test where when "yes" is true it inserts the date?

this is what i have now ...

=IF(V17="yes","d/mm/yyyy","")

but d/mm/yyyy is what comes out not the actual date?
Can this be done or am i dreaming?

It depends on what date you mean. If the date is typed manually into a cell, then yes, you could do this (assuming the date was typed into cell X1)...

=IF(V17="yes",TEXT(X1,"d/mm/yyyy","")

However, if the date comes from one of the DATE functions, you can still do the above, for example...

=IF(V17="yes",TEXT(NOW(),"d/mm/yyyy","")

but the date will change every day when the sheet is recalculated.