Date Ranges / Ignore Blanks

[ALETHIA]

I am tracking days in between product completion. I would like the formulas to ignore blanks. =DATEDIF(G2,H2,"D")

I have been struggling to add in the ignore blank command...

Also, I would like to make a chart based on one column. The column can have 12 possible answers. I'm looking for help to count the amount of each auto answer, and place it into a pie graph.

Thank you for your time.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(OR(G2="",H2=""),"",DATEDIF(G2,H2,"D"))