Another Formula
 

Ok, this has been a very helpful forum so here goes another.

I have 3 columns D2 (with a date ie 20 Aug 09), F2 (with a date or not ie 22
Aug 09 or blank), and G2 which is the total days between the 2 dates (2
days). The formula below is what gives me the total days, but in F2 without a
date, it gives me a negative number. I don't want any number to appear there
if F2 is blank. Help

=DAYS360(D5,F5,FALSE)

Another Formula
 

Try
=IF(F2,DAYS360(D2,F2,FALSE),"")

If this post helps click Yes
---------------
Jacob Skaria


"Help with cell function" wrote:

Ok, this has been a very helpful forum so here goes another.

I have 3 columns D2 (with a date ie 20 Aug 09), F2 (with a date or not ie 22
Aug 09 or blank), and G2 which is the total days between the 2 dates (2
days). The formula below is what gives me the total days, but in F2 without a
date, it gives me a negative number. I don't want any number to appear there
if F2 is blank. Help

=DAYS360(D5,F5,FALSE)

Another Formula
 

=IF(F5="","",=DAYS360(D5,F5,FALSE))

--
__________________________________
HTH

Bob

"Help with cell function"
wrote in message ...
Ok, this has been a very helpful forum so here goes another.

I have 3 columns D2 (with a date ie 20 Aug 09), F2 (with a date or not ie
22
Aug 09 or blank), and G2 which is the total days between the 2 dates (2
days). The formula below is what gives me the total days, but in F2
without a
date, it gives me a negative number. I don't want any number to appear
there
if F2 is blank. Help

=DAYS360(D5,F5,FALSE)

Another Formula
 

Hi,
=if(F2="","",DAYS360(D5,F5,FALSE))

if this helps please click yes, thanks

"Help with cell function" wrote:

Ok, this has been a very helpful forum so here goes another.

I have 3 columns D2 (with a date ie 20 Aug 09), F2 (with a date or not ie 22
Aug 09 or blank), and G2 which is the total days between the 2 dates (2
days). The formula below is what gives me the total days, but in F2 without a
date, it gives me a negative number. I don't want any number to appear there
if F2 is blank. Help

=DAYS360(D5,F5,FALSE)