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