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

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining several cells into single equasion? 1
Does date in Cell A1 occur between the date in M1 and Date in X1 1
Column of Text is same as Column of Values 2
Confused beginner 6
How to insert a value in one cell into many cells 17
Count non-consecutive cells..... 7
LookUp (Date) Value from Forecast Data - From 2nd Sheet 3
Ignore blank cells in formulas & in average 4

Back
Top