Simple IF function query (hopefully)

[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,

[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

Dav

[paul]

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

paul
[email protected]
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
>
>

[ahaigh]

That's great,

Cheers