Counting days formula

Here is the formula I use:

=DATEDIF(B6,TODAY(),"D")

to calculate # of days from date I entered.
However when I left the cell blank, it gives it a value of 38607.
How can I get it blank if I don't enter a date? It affect the whole spreadsheet.

Thanks.

Hi

=IF(B6="","",DATEDIF(B6,TODAY(),"D")
or
=IF(B6="","",TODAY()-B6)


--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )



"cardingtr" <cardingtr.1va76c_1126587931.1562@excelforum-nospam.com> wrote
in message news:cardingtr.1va76c_1126587931.1562@excelforum-nospam.com...
>
> Here is the formula I use:
>
> =DATEDIF(B6,TODAY(),"D")
>
> to calculate # of days from date I entered.
> However when I left the cell blank, it gives it a value of 38607.
> How can I get it blank if I don't enter a date? It affect the whole
> spreadsheet.
>
> Thanks.
>
>
> --
> cardingtr
> ------------------------------------------------------------------------
> cardingtr's Profile:
> http://www.excelforum.com/member.php...o&userid=27027
> View this thread: http://www.excelforum.com/showthread...hreadid=467031
>