I am using an "if" function & when it is true I want to return todays date,
all I can get it to return is =today(), please can someone suggest anything
Thanks
Sally

I presume you have something like:

=IF(condition,TODAY(),"")

Format the cell in date format.

Hope this helps.

Pete

my formula lokks like below;
=if(condition,""," ","=today()")
if the cell is empty return blank if not return todays date, when using the
above formula it returns =today() instead of the date....
--
Thanks
Sally


"Pete_UK" wrote:

I presume you have something like:

=IF(condition,TODAY(),"")

Format the cell in date format.

Hope this helps.

Pete

Sally,

by putting =today() in quotes, you are turning this into text - the
quotes are not need, neither is the equals sign. Also, you have too
many parameters. Try something like:

=IF(A1="","",TODAY())

which means if A1 is blank then return a blank, otherwise return
today's date.

Hope this helps.

Pete

Hi

It must be:
=if(condition,""," ",today())


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Sally" wrote in message
...
my formula lokks like below;
=if(condition,""," ","=today()")
if the cell is empty return blank if not return todays date, when using
the
above formula it returns =today() instead of the date....
--
Thanks
Sally


"Pete_UK" wrote:

I presume you have something like:

=IF(condition,TODAY(),"")

Format the cell in date format.

Hope this helps.

Pete

Should just be something like

=IF(A110,TODAY(),"")

format as date


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=539806

Some variation of this might be what you want. With it, the date will not
change tomorrow when you open the file........

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Range("a1").Value = "True" Then
ActiveCell.FormulaR1C1 = Date & " " & Time
End If
End Sub


Vaya con Dios,
Chuck, CABGx3



"Sally" wrote:

I am using an "if" function & when it is true I want to return todays date,
all I can get it to return is =today(), please can someone suggest anything
Thanks
Sally