Return null

[Karen]

I am trying to return a null value (blank cell) for this report.

A B C
D
No. Final sent date Status Final filed - month
17 3-Mar-08 Completed Mar
18 9-Jan-08 Completed Jan
19 (blank) In progress Jan
20 (blank) In progress Jan

My problem:
I have the formula =TEXT(C10,"mmm") in the "Final Filed - month" column

I want to result in for item no. 19 and 20 to be blank in column D instead
of stating Jan (which is incorrect).

Please, what is the formula?

 

[Dennis]

Should your formula refer to B10 and Not C10 as C10 is the status ??
Assuming it should be column B, use
=IF(ISBLANK(B10),"",TEXT(B10,"mmm"))

 

[Karen]

Thanks Dennis. That was great!

What if column B row 19 shows the value of 1/0/1900 (which returns 0-Jan-00
in date format). What would my formula be?

A B
17 3-Mar-08 Completed Mar
19 0-Jan-00 In progress Jan

Karen

 

[Dennis]

Try this
=IF(OR(ISERROR(DAY(B19)),ISBLANK(B19)),"",TEXT(B19,"mmm"))