Help! Urgent

[mikeeee]

Column a = a date such as 1/25/04. Column b = a later date such as 2/25/04
Column c = the total number of days between the two dates.
The problem I am having is when I don't have a date in column b yet I get the
#VALUE! or FALSE message. Is there a way to still have the formula in the cell without getting the error messages, ie the c cell just stays blank if there is no date in b yet? Also if I am entering these dates down a column say 100 lines or so. Column d I need to tell me what the average number of days is of column c again without error messages. The formula I am using in C is
=IF(B1>0,B1-A1) If B1 does not have a date yet I get the error message.
The formula I am using for D is =AVERAGE(C1:C100) Any help would be greatly appreciated as usual.

Thanks in Advance

[Rutgers_Excels]

See my last post to you.

IF(B1="","",B1-A1)

[BenjieLop]

Column a = a date such as 1/25/04. Column b = a later date such as 2/25/04
Column c = the total number of days between the two dates.
The problem I am having is when I don't have a date in column b yet I get the
#VALUE! or FALSE message. Is there a way to still have the formula in the cell without getting the error messages, ie the c cell just stays blank if there is no date in b yet? Also if I am entering these dates down a column say 100 lines or so. Column d I need to tell me what the average number of days is of column c again without error messages. The formula I am using in C is
=IF(B1>0,B1-A1) If B1 does not have a date yet I get the error message.
The formula I am using for D is =AVERAGE(C1:C100) Any help would be greatly appreciated as usual.

Thanks in Advance

Try this ...

=if(B1="","",B1-A1)

[mikeeee]

Thanks for the help

[mikeeee]

Formula works but still get the #VALUE! error on the empty cells.

Any suggestions?

[Rutgers_Excels]

What is the formula where the error is coming up? Is it the =if(B1="","",B1-A1) formula or is it in a different formula? Can you give me an example?

[Cutter]

I tried your formulas and didn't get any errors.

I did, however, get the #VALUE error when I typed the dates exactly as you show them. That's because on my comp in order to type the date of Jan 25, 2004 I type 4/1/25.
If you typed 1/25/04 and entered did the "date" stay to the right of the cell (if it did it was recognized) or did it move to the left (if so did its not a valid date)?

Make sure your date entries are recognized as dates and your formulas will work.