skip the blank cells

[Abdulkhadar]

Hello Excel experts,
I use a formula in Sheet2 from B10 to B100 cells.
=IF(DATEDIF(Sheet1!C10,Sheet1!$F$9,"Y")>=59,Sheet1!B10,"")
i want to skip the blank cells in Sheet. Sheet2 protected only B10 to B100 cells are not protected.
Thanks in advance.

 

[pbornemeier]

This will skip blank cells in Sheet 2 column C

=IF(AND(DATEDIF(Sheet1!C19,Sheet1!$F$9,"Y")>=59,Sheet1!C19<>""),Sheet1!B19,"")

 

[Abdulkhadar]

This will skip blank cells in Sheet 2 column C

=IF(AND(DATEDIF(Sheet1!C19,Sheet1!$F$9,"Y")>=59,Sheet1!C19<>""),Sheet1!B19,"")

Thanks for reply,

 

[lezawang]

This will skip blank cells in Sheet 2 column C

=IF(AND(DATEDIF(Sheet1!C19,Sheet1!$F$9,"Y")>=59,Sheet1!C19<>""),Sheet1!B19,"")

Hi
Can I ask some question. Is this formula written in Sheet 2? Can you please break it down. Thanks alot.

 

[Abdulkhadar]

Hi
Can I ask some question. Is this formula written in Sheet 2? Can you please break it down. Thanks alot.

Yes, formula is in Sheet2. I want if age is less than 59 then skip the cell or delet the entire row. I think it can be done by VB. Thnaks