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,


--
ahaigh
------------------------------------------------------------------------
ahaigh's Profile: http://www.excelforum.com/member.php...o&userid=32414
View this thread: http://www.excelforum.com/showthread...hreadid=531477

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

Try =IF(AND(J10,U10),U1-J1,"") as you calculation

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=531477

=IF(OR(ISBLANK(J1),ISBLANK(U1)),"",J1-U1)

paul

remove nospam for email addy!



"ahaigh" wrote:


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,


--
ahaigh
------------------------------------------------------------------------
ahaigh's Profile: http://www.excelforum.com/member.php...o&userid=32414
View this thread: http://www.excelforum.com/showthread...hreadid=531477

That's great,

Cheers


--
ahaigh
------------------------------------------------------------------------
ahaigh's Profile: http://www.excelforum.com/member.php...o&userid=32414
View this thread: http://www.excelforum.com/showthread...hreadid=531477