Simple IF function query (hopefully)

A

ahaigh

Hi,

I have two columns (J & U) that contains date values (dd/mm/yyyy if
it's important.)

I know how to calculate the number of days between the two which I've
done in column V, however in some cases one or both of columns J & U
are blank. In these cases I'd like my results column to just return
blank also.

Can I make this happen using an IF function? I'd use conditional
formatting, but really just need the cell to contain no value at all
rather than one I can't see.

Thanks in advance,
 
D

Dav

If J contains the start date and U contains the end date

Try =IF(AND(J1>0,U1>0),U1-J1,"") as you calculation

Regards

Da
 
Top