ExcelBanter - How to supress result (39411) of Fn =TODAY()-J1 when J1 is blank

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to supress result (39411) of Fn =TODAY()-J1 when J1 is blank (https://www.excelbanter.com/excel-worksheet-functions/167281-how-supress-result-39411-fn-%3Dtoday-j1-when-j1-blank.html)

Mike

How to supress result (39411) of Fn =TODAY()-J1 when J1 is blank

Hi there,

I am trying to find # of days as =today()-cell J1. When J1 is not populated
the cell displays 39411. Is there a way to suppress display when cell value
is not entered

vezerid

How to supress result (39411) of Fn =TODAY()-J1 when J1 is blank

=IF(J1="","",TODAY()-J1)

HTH
Kostis Vezerides

On Nov 25, 8:38 pm, Mike wrote:
Hi there,

I am trying to find # of days as =today()-cell J1. When J1 is not populated
the cell displays 39411. Is there a way to suppress display when cell value
is not entered

David Biddulph[_2_]

How to supress result (39411) of Fn =TODAY()-J1 when J1 is blank

=IF(J1="","",TODAY()-J1)
--
David Biddulph

"Mike" wrote in message
...
Hi there,

I am trying to find # of days as =today()-cell J1. When J1 is not
populated
the cell displays 39411. Is there a way to suppress display when cell
value
is not entered

T. Valko

How to supress result (39411) of Fn =TODAY()-J1 when J1 is blank

Try this:

=IF(J1="","",TODAY()-J1)

--
Biff
Microsoft Excel MVP

"Mike" wrote in message
...
Hi there,

I am trying to find # of days as =today()-cell J1. When J1 is not
populated
the cell displays 39411. Is there a way to suppress display when cell
value
is not entered

All times are GMT +1. The time now is 02:27 AM.