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.


--
cardingtr
------------------------------------------------------------------------
cardingtr's Profile: http://www.excelforum.com/member.php...o&userid=27027
View this thread: http://www.excelforum.com/showthread...hreadid=467031

Hi

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


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"cardingtr" wrote
in message ...

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