FORMULA FOR IGNORING A BLANK CELL WITHIN A COLUMN WITH FORMULA SET
Hello,
I want to count the number of days from task set vs the due date set. I know the formula for that which is NETDAYS however, on empty spaces that I don't want filled in, INVALID DATA shows. So I want to know how to ignore the formula on blank cells. Can someone help me please?
Column names:
Original End Date, New End Date and
Planned Task Hours
Best Answer

Hey @DianeKayle,
I generally put in an IF statement to see if a cell is blank. The formula below checks to see if Original End Date is blank and if it is returns blank but if it's not blank it will preform the calculation.
=IF([Original End Date]@row = "", "", NETDAYS([Original End Date]@row, [New End Date]@row))
Answers

Hey @DianeKayle,
I generally put in an IF statement to see if a cell is blank. The formula below checks to see if Original End Date is blank and if it is returns blank but if it's not blank it will preform the calculation.
=IF([Original End Date]@row = "", "", NETDAYS([Original End Date]@row, [New End Date]@row))

Hi Devin, that helped however, I also need a formula if one of the 2 cells involved is blank. Can you help?

Try wrapping you formula with an IFERROR
IFERROR(your formula here, " ")
Help Article Resources
Categories
Check out the Formula Handbook template!